Jump to content

Recommended Posts

When I try to execute

_SQLite_Exec($database, "UPDATE threads SET " &_
    "threadno = '"&StringTrimRight($t_file, 5)&"', " &_
    "title = '"&$t_title&"', " &_
    "poster = '"&$t_poster&"', " &_
    "genres = '"&$t_genres&"', " &_
    "time = '"&$t_time&"', " &_
    "pages = '"&$t_pages&"', " &_
    "thumbnails = '"&$t_tblist&"', " &_
    "size = '"&$t_size&"' " &_
    "WHERE threadno = '"&StringTrimRight($t_file, 5)&"';")

I get a "missing separator after keyword" error. What am I missing?

Link to post
Share on other sites
  • Moderators

Quinch,

See the Help file <Language Reference - Comments>:

"Although only one statement per line is allowed, a long statement can span multiple lines if an underscore " _" preceded by a blank is placed at the end of a "broken" line.

Add a space between the final character of each line and the underscore and it should work. :)

M23

Edited by Melba23
Fixed tags

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

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
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...