how to use row_pointer
Posted: Tue Apr 22, 2003 4:12 am
this is my first post here - so hello people!
now to my question: i did a dynamic linklist where everybody can enter url's and they are shown again in the list, so this part works quite well already. i gave the values in the database an ID (it's an own column) and i use this to query specific lines. now when i wanna update one value thats no problem but when i wanna delete the whole row i have one missing ID-number which hinders my query from working right, so i would have to replace the ID after every delete - now my question is is there any way to read the line-number without giving it an explicit ID, i read about that row_pointer but i don't really know how to use it yet, is it incremented by every operation quite like a streamreader or do i have to set it? and is it possible to do a query like WHERE row_pointer = something... ?
thanks in advance!
oh and another thing: what data-type should i take to store a complete file (about 1 -2 mb) in a database - i know this might sound strange but it would really help me...
now to my question: i did a dynamic linklist where everybody can enter url's and they are shown again in the list, so this part works quite well already. i gave the values in the database an ID (it's an own column) and i use this to query specific lines. now when i wanna update one value thats no problem but when i wanna delete the whole row i have one missing ID-number which hinders my query from working right, so i would have to replace the ID after every delete - now my question is is there any way to read the line-number without giving it an explicit ID, i read about that row_pointer but i don't really know how to use it yet, is it incremented by every operation quite like a streamreader or do i have to set it? and is it possible to do a query like WHERE row_pointer = something... ?
thanks in advance!
oh and another thing: what data-type should i take to store a complete file (about 1 -2 mb) in a database - i know this might sound strange but it would really help me...