well i think I find out how to save it:
[code]
qry.recordset.save('C:\filename.txt',0); //what is this number?
[code]
But I'm realy wondering how to read data from file?
Well, in my app, when I click few times same check box button and try to save it I got the error:
Row cannot be located fro updating. Some values may have been changed since it was last read.
I work with Delphi 7, connecting to MySQL database. Also, I'm using IP controls (InfoPower) checkbox...
After installing SP2 on winXP SP1 I left automatic updates on, and after automatic installation one of it my comp. asked me to restart machine... After that my computer boots, running for 10 sec with "Windows XP" screen and then blue screen for second and restart... Same in safe mode! SO no...
Well strange problem, When I try to join two tables I get no error but I get no results also! I use InnoDB and foreign keys, I dont know is there some problem whit that? MySQL is 4.1.18-max which goes with SUSE Enterprise Server 9!
this statement works (one table):
'SELECT T.id, T.name FROM...
I have a mysql database with 28 tables, and I need to make a backup of that DB from my app. Is there any sql statement for getting whole DB in form of SQL query, so I can simple run that query again and get my DB back?
PLZ help it's urgent!
I have memo fields in my application, connected to mediumtext fields in my mysql table, but Delphi don't recognize size of the field in database and allow's me to enter only few chars in my memo field... sometimes 6 and sometimes 200! But I need much more! PLZ HELP!
First myODBC is 3.51.12, and MySQL remote server is on SUSE LINUX Enterprise Server 9, version 4.0.18-max
I'm conected to server and my app works just fine, and I was connecting to MySQL over ODBC (my app is running on winXP)! It was good while I was using only USERNAME with blank PASSWORD in...
I want to add a control in my form, so when user click save data I need to check are all required fields not empty! I tried OnBeforePost, I make a control so I know are some field empty or not, but I don't know how to stop execution of that insert!? I'm using ADOTable component!
PLZ HELP!!!
I'm using TTable and MySQL DB on remote server! In DB I have mediumtext field (up to 16000 chars I think), but my memo field allow me only 100 chars, it cut's all the rest after I leave field... Well I have 3 memo fields, and all three allow me to enter different no of char's... Between 75 and...
Well I need to fill my DB to test speed...
So I need procedure to do it! I made a loop, TADOQuery.... Well problem is, after first record is entered in database I got message 'CommandText does not return a result set' and I'm out of loop...
Here is some code...
for i:=1 to 50000 do
begin...
So I need two unique fields in my table, but they should not be unique separately, just a combination of values in this two fields... Let's say I have table with fields book, page, text... I can have more then one book #1, more than one pages #1 but only one combination of book #1 and page #1...
Well I think you will find my question stupid, but I'm beginer, so plz help!
I need to make one form for several code forms... They all looks allmost the same, with code and name fields, and with grid to show existing data! For now it's ok! But I have city code, country code, street code and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.