Sign in to follow this  
Followers 0
Kombat

SQLite multi line syntax

3 posts in this topic

Does anyone have a suggestion on how to format the following on multiple lines:

_SQLite_Exec($hDB, "CREATE TABLE Administrator,AdministratorName,Password);")

I tried:

_SQLite_Exec($hDB, "CREATE TABLE Administrator_

AdministratorNumber, _

AdministratorName,_

Password);")

but the editor rejects it.

Share this post


Link to post
Share on other sites



You can't "continue-line" in the middle of something.

This should work better:

_SQLite_Exec($hDB, "CREATE TABLE Administrator" _
& "AdministratorNumber," _
& "AdministratorName,"_
& "Password);")

Share this post


Link to post
Share on other sites

Does anyone have a suggestion on how to format the following on multiple lines:

_SQLite_Exec($hDB, "CREATE TABLE Administrator,AdministratorName,Password);")

I tried:

_SQLite_Exec($hDB, "CREATE TABLE Administrator_

AdministratorNumber, _

AdministratorName,_

Password);")

but the editor rejects it.

Thank you, that was the information I needed.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0