• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Doubt on Select and Fetch single

deva raju

Member
Hi All,
Am new to this site and please clear my doubt.
Can we keep Select and Fetch single??If "YES", what will be happen..
 

bitfreeze

Member
Fetch Single discards any previous filters.

- - -

We may compare those commands to SQL statements:
Select prepares the "where" conditions, filters based on any fields from the Table/View.
Fetch Next defines the "select"ed fields, for each record returned.

Now Fetch Single does both operations as one:
Fields from the selected index become conditions - equivalent to a Select command;
Any other fields are the returned data - equivalent to a Fetch Next.
 
Hi Deva raju,

Actually if you use fetch single, without passing a key input parameter it won't allow you to save and exit. so that there is no question of select and fetch single. you have to pass the key and fetch the record using fetch single only. You can reach me out at naidubabu.jdetech@gmail.com

Regards,
k A Naidu
 

deva raju

Member
Hi KallaANaidu,
I din't say am not passing any values in Fetch single. Actually this is earlier code, they are passing some fields in Select and some other fields in Fetch single. :)
 

deva raju

Member
Select and Fetch single

I got it.. Without Fetch next if we are using Select and passing any values i.e waste only.so Obviously here Fetch single will work.
Thanks guys for responding.:)
 
Top