How to retrieve???

[Gary Stout]

I am finally getting the ball rolling with SQLitening after putting it off for way too long now.

I have a table that contains 5 fields :

FamilyID   
MemberID   
TransID   
BatchID   
EventID   


This table basically stores program information for the next Transaction # ID, for example. There will never be more than 1 record in the table.
Since I don't know exactly what the TRANSID will be, how can I retrieve this field value without doing a search for unknown information?
In other words, if this was a random file, I would retrieve the record by record number, without searching, and use the value that the record held.

hopefuly this makes sense 

Gary

[Marc Giao]

Hi Gary,

Assume the table is called "tbl_ids" and the fields contain strings, then it would be as follows:

Code Select Expand


slSel "SELECT * FROM tbl_ids"

slGetRow
a$ = slFN("FamilyID")
b$ = slFN("MemberID") 
c$ = slFN("TransID")
d$ = slFN("BatchID")
e$ = slFN("EventID")
slCloseSet 'just in case you have more rows and don't know it :)


That's it, hope it helps.

Marc

[Gary Stout]

Marc,

Thanks for the reply! 
In searching the forums, I did find something that seemed to work ok. I do understand your example as well.

Code Select Expand


slSEL "Select * FROM ProgramData WHERE RowID = 1", %rs1


Gary

[Marc Giao]

Hi Gary,

Yes, that will do it too but I prefer not to reference rows so here is one more way if you just want one or more fields:

slSel "SELECT TransID FROM PorgramData"

Don't you just love how simple it is

Marc

[Gary Stout]

Don't you just love how simple it is

I do love the simplicity. I have been able to eliminate a bunch of Tsunami search code. With Sqlitening, it is amazing how few lines of code will do the same thing and more. 
Much more control over how the data is retrieved.