load settings

Databases
#1

[code] sql = "SELECT intID, strEmail, strPassword FROM [settings] "

dim rs as RecordSet = dbDatabase.SQLSelect(sql)

textEmail.text =  rs.Field("strEmail"). StringValue   <--------------- error
textPassword.text =  rs.Field("strPassword"). StringValue[/code]

I get error message on this line. What could be the case?

#2

You have a space between the full stop and StringValue.

#3

True. I now see. But the thing is, the code is copy/paste and it used to work…
I was hoping for a different solution…

It is still error, even without the space.

Maybe the image can give a hint of the issue?

#4

Whats the error ?

#5

“No such table”
Thank you!!

#6

sql = "SELECT intID, strEmail, strPassword FROM ‘settings’ "

#7

why do u need to [] around setting in the SQL?

#8

You don’t. I believe it was a hold-over from VB (at least I remember using [] there alot.

Also… [quote=53151:@Derk Jochems]sql = "SELECT intID, strEmail, strPassword FROM ‘settings’ "[/quote]
No need to quote the table name either… unless it has a space in it.

#9

that is why i always use one word for fields and table name. eg FirstName and tblClientAddress

#10

As a matter of fact… ORACLE will reject your SQL if you quote field or table names… so depending on your goals, it might be a good practice to get into (unless you are handed a database and have no choice)

#11