Hi all,

I created a global datastore to retrieve SMTP email settings... when I retrieve the datastore, the retrieve function returns -1.  I know there is 1 record in the database, and the record shows up in the datawindow painter. 

Here's the code in the open event of my MDI frame:

gds_smtp_settings = CREATE datastore
gds_smtp_settings.dataobject = "d_smtp_settings"
gds_smtp_settings.SetTransObject( sqlca )
integer li_rc
li_rc = gds_smtp_settings.Retrieve()
messagebox("smtp settings rowcount", li_rc)

gds_smtp_settings is declared as a global variable... datastore gds_smtp_settings

Any rooky moves in the code/logic?  Using PB2022 R2, PFC2022.

TIA,

Tracy