Brian,
This is really not a NT question and you may get better answers in the Clarion ng's.
But since you asked <g>:
After issuing the prop:sql stmt you must actually read the result. So something like this:
SQLFile{PROP:SQL}='SELECT SUM(filecount) FROM custvf where readyforbilling=<39>Y<39> AND invoice=0 AND cussysid=' & cus:cussysid
if error()
! Always do some error checking here
else
loop ! Read one row at a time from the result set (= the structure of your sqlfile)
next(SQLFile)
if error() then break.
! Now you've got some data so use it:
YourFileCountVar = sqlfile.NameOfTheFirstField
end
end
Each next() in the loop retrieves the next row from the result set. In this case there's only one row but now you've got a generic way of doing it. Also, inside the loop do an error check as shown (it may be more advanced but in the example above it catches EOF).
HTH
Peter
Topic: PROP:SQL (Read 3194 times)