Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>If SQL is static (not changing on the fly) easiest is to put SQL directly to >grid.recordsource and set recordsourcetype = SQL. It seems you set >recordsourcetype = alias and the alias is the one you're selecting into.
Hi,
Thanks for your suggestions. I've tried putting the SQL statement
into grid.recordsource & also set the recordsourcetype to SQL. I'm
still not getting anything, what i suspect is that the grid is being
initialized at the very begining & thus not registering my search
criteria or rather the SQL statement in the grid.
Just for your info a sample of my sql statement. Take note of the WHERE clause
eg:
Select cds.ncode, songs.csgname from cds inner join songs on
cds.ncode=songs.ncode WHERE songs.csgname =
alltrim(thisformset.form2.key.value) order by songs.csgname
Thanks
Andrew Kong
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement