Android Question Use a SQLite table name stored in a variable

F

Fab117

Member
Licensed User
Longtime User
Hello,
I have a SQlite database with lots of tables.
From an initial query, I stored the name of the future table I will need in a string variable (RefSousCategorie)
Now I would like to use data's srored in this table under the field "Nature".
I tried with
B4X: 
Cursor1 = Main.SQL1.ExecQuery("SELECT Nature FROM RefSousCategorie")
But I have an error message, because it looks for the table named "RefSousCategorie" instead the name stored in this variable.

Do someone know how to use correct code ?

Thanks and have a nice Sunday.

Fab
 
Sort by date Sort by votes
F

Fab117

Member
Licensed User
Longtime User
Hi Don Manfred,
Similar question.
In table "ContenuActuel", I have 10 Fields

I want to add one line in my database.
Most of the data's to add are stored in string or int variables.
Based on support from last Sunday, I tried:
Main.SQL1.ExecNonQuery("INSERT INTO ContenuActuel VALUES (&DateDeCongelation, &NouvelleCategorie, &NouvelleSousCategorie, '3', &Source, &DateDExpiration, null, null, null, null)")

NB: When I write:
Main.SQL1.ExecNonQuery("INSERT INTO ContenuActuel VALUES ('tttt', 'zzzzzz', 'uuuuuuu', '3', 'ggggggggggg', 'ffffffffffffffff', null, null, null, null)")

It is working.

Thanks for your help

Fab
 
Upvote 0
S

sorex

Expert
Licensed User
Longtime User
concatenating variables should be done by

closing the string with a double quote
add &
add variable
add &
re-open the string with a double quote

B4X: 
Main.SQL1.ExecNonQuery("INSERT INTO ContenuActuel VALUES ('"&DateDeCongelation&"', '"&NouvelleCategorie&"', '"&NouvelleSousCategorie&"', '3', '"&Source&"','"&DateDExpiration&", null, null, null, null)")

note the single quotes needed for date fields (at least in mssql/mysql)

Edit: I adjusted the single quotes to your example so ignore the line above.
 
Last edited:
Upvote 0
F

Fab117

Member
Licensed User
Longtime User
Dear Sorex,

Thank you for your help.

Unfortunately, a copy/paste from your proposal doesn't work.

Based on your explanation, I tried some changes, such as:
Main.SQL1.ExecNonQuery("INSERT INTO ContenuActuel VALUES (" & DateDeCongelation & ", " & NouvelleCategorie & ", " & NouvelleSousCategorie & ", '3', " & Source & ", " & DateDExpiration & ", null, null, null, null)")
without success.

Fab
 
Upvote 0
S

sorex

Expert
Licensed User
Longtime User
put the query string into a string variable and use a log() command with it.

then you can copy and paste it in your sqlite editor to see what's wrong.
 
Upvote 0
M

Mahares

Expert
Licensed User
Longtime User
Fab117 said:
I tested your updated code, but unfortunately, still not working
Click to expand...

Most generally, it is much easier and more readable to use a parameterized query as shown below to avoid having to mess around with single quotes.
B4X: 
Main.SQL1.ExecNonQuery2("INSERT INTO ContenuActuel VALUES (?,?,?,?,?,?,?,?,?,?)", _
Array As Object(DateDeCongelation, NouvelleCategorie,NouvelleSousCategorie, 3, Source, DateDExpiration, Null, Null, Null, Null))
Bonne chance
 
Upvote 0
E

edgar_ortiz

Active Member
Licensed User
Longtime User
sorex said:
put the query string into a string variable and use a log() command with it.

then you can copy and paste it in your sqlite editor to see what's wrong.
Click to expand...

I think that a parametrized query is a nice option.

But I prefer create a string with the command and then execute the query.

Regards,

Edgar
 
Upvote 0
F

Fab117

Member
Licensed User
Longtime User
Mahares,
Your code is working perfectly, thank you.
The others, thank you also for your help. I tried to create a string with the command without success.
When I will have more time, I will try to investigate more on it.

Have a nice Sunday.

Fab
 
Upvote 0
You must log in or register to reply here.

Similar Threads

P
  • Question
Android Question Truncated input message - B4XDialog from XUI Views
Replies
5
Views
838
Mahares
M
  • Question
Android Question A unique code for a sqlite field
Replies
13
Views
2K
Daniel44
  • Question
Android Question It is possible to cut videos ???
Replies
1
Views
811
Erel
S
Wish Forms
Replies
6
Views
1K
MarkusR
  • Question
Android Question Process timed out.
Replies
13
Views
3K
Multiverse app
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…