PureBasic Forums - English

If you have access to the MySQL server, you should use LOAD DATA INFILE and a CSV file, it is considerably faster than successive INSERTs. (in SQLite .import)
With 10,000 records it should take a few seconds.


Thanks for the reply. I am not sable to go down the LOAD DATA route as the CSV I am ...

Here is some code I have knocked up to try and understand who it all would work. It all about the code between the -------------------------------

The MySQL Database is on my local machine, there is an 64bit ODBC connection linked to MySQL


MySQL_Username.s = "root"
MySQL_Password.s ...

Thanks for the replies, I got it working great a few days ago but then came across another few issues and been stuck even though I have tried quite a few permutations on writing the code.

When using SQLite there was no limitation on the size of the query string, however on MySQL (via ODBC) there is ...

Not an answer, but are you sure about "BEGIN:" :?:
I use "BEGIN;".

Yes, I did mean ; I mistyped whilst writing this post. The actual code does have a ;

As for infratec reply, I have tried various BEGIN; or BEGIN TRANSACTION; or START TRANSACTION; but still can not get a multi INSERT to actually ...

Hi,

For a few years I have been importing database records into SQLite using the following code.

Query$ = "BEGIN: " + #CRLF$
Query$ = Query$ + "INSERT INTO `mytable` (`ID`, `Date_TS`, `HTeam`, `ATeam`, `FTG`, `FTA`, `FT`) VALUES (0, 1533340799, 'Jordan', 'Jack', 0, 0, 'Z');" + #CRLF$
Query ...

kenmo wrote:

Code: Select all

DesktopMouseX()
DesktopMouseY()

Thanks, I have spent ages trying all the mouse stuff and never knew this Desktop Enviroment. Thanks

Hi, How to get mouse coords across the whole monitor setup without having an open window or screen?? It just does not seem possible to use the mouse functions without enabling sprites or opened windows.

Example of what I have been trying to achieve.

A PB application to reside in the Taskbar. This ...

Thanks

sorry for my bad coding

Hi All,

How to store variables of different types in one way.

OK, I have lots of individual variables in my software

aa=1
ab=2
ac="Tree"
ad=4
ae="Roots"
af=12212.2
etc etc

but now looking to handle these variables in a better way. I first looked at an Array but you can not store different ...

Thank you so much

Hi,

I am looking to add an editorgadget to a window to act as a location for notes, however I can not seem to get the text to correct along with the wordwrap. Is there a special way to solve this?
The attached code is taken from the EditorGadget help file with the addition of some long sentences ...

Thanks for the pointers. :-)

Here is the code with the unicode alteration for anyone else who might like to check for variables and unused declared variables.
EnableExplicit

#maxVars = 1000

#var_use_noUse = %00000000000000
#var_use_anyUse = %00000000000001
#var_use_argument = %00000000000010 ...

if anyone who has a old copy of PB hanging around that is installed on their system, could you compile
You can download old PureBasic copies from your online account at PureBasic.com :)
I know, I just did not want to try install a few old copies in seperate area and mess with cfg files just to ...

Thank you all for your help

Thank you for your help