Jump to content

SQLite multi line syntax


Recommended Posts

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.

Link to comment
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);")
Link to comment
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.

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...