PureBasic Forums - English

Hi

I have tried Japbe and prefer its layout and tools over the purebasic IDE, but I have had to shift back to the purebasic IDE because it allows you to run code in the IDE without having to save it first , ie you can change things in the code and run it , but if something goes wrong you can ...

Thats true

I was getting frustrated that inputing a simple quote character into a field would screw up the SQL query string, but thinking about it, these are the anomolies that have to be overcome in order to create compact, efficient, fast apps with no dependencies.
Thats why I am trying this ...

Kiffi

You may well be getting my nomination for resident Forum Genius

Tried your suggestion and changed my procedure accordingly
Procedure PMRecordInsert()

InsertCAT = GetGadgetText(#ComboBoxCATEGORY)
InsertDESC = GetGadgetText(#StringDESCRIPTION)
InsertCODE = GetGadgetText(#EditorCODE ...

Thanks srod

I tried adding a single quote to my single quote and it indeed inserts the text as required, when it loads the field it ignores the extra quotes and displays the original text without my additional quote,BUT if I edit the text I have to add the additional quotes again to save it ...

Sorry for not being specific in the title of my post

I have tried the above suggestions and the result is the same as my original code, thanks for trying
Having spent hours working on this problem I am now getting nearer to a solution

the text that i am trying to write to the Sqlite database ...

Hi
I have moved from VB6 to purebasic and am trying to write the contents of a editorgadget to a SQLite database the procedure I am using works , but when the editorgadget contains indented formated PB code (I am writing a code library) it does not insert into the database.
Also if I input the same ...