SGroupFetch1
I trying these, and get no value
sSQL =
"SELECT COUNT(*) FROM X_Table"Call sql(iCSR, sSQL)iRV = SGroupFetch1(iCSR, bX_Table)
Call SqlFree(iCSR)*This post is locked for comments
Hi,
I have same problem buffer size it does not enough, you are saying bcount * 10 but bcount is integer..
how can you do that?please can you help me?
Paul,
I used your example and worked ok.
Then i tried these:
Dim sSQL As String, iCSR As Integer, lCount As Integer, iRV As IntegersSQL =
"SELECT COUNT(*) FROM X_Table"Call sql(iCSR, sSQL)iRV = SGroupFetch1(iCSR, lCount)
Call SqlFree(iCSR)And works ok too, The problem seems to be the short variables.
Thanks again.
By other hand, you said that sometimes the buffer sizes is doesn't enough, what i'm do is these:
bCount * 10.
Greetings,
Rob
Thanks Paul,
Your help was very useful, i'm on 7.0 version
Thanks
Rob
Hi Rob,
You didn't mention which version you are on, but here is an example I have used on version 7.0. I haven't tested it on prior versions. I did have some issues with the SGroupFetch call throwing an error 10202 (The application fetch buffer size is less than the cursor select statement requires).
Here is the example I used. A few things to note:
Dim bCount As Integer
Dim CSR_PJPROJ As Integer
Call sql(CSR_PJPROJ, "SELECT COUNT(project) FROM PJPROJ WHERE project=’abc’")serr1 = SGroupFetch1(CSR_PJPROJ, bCount)Hope this helps,
Paul Phillips
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156