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...
NO, I can't access recovery console :( Thats the part "Setup is inspecting your computer hardware" and after that some options should show, including RC, but not now in my case!
I can boot only from win 98 startup disc, but all my partitions are NTFS or linux partitions so I can't see any of them
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...
You are not following me dont you? ;) I told you it's not empty, on one server everything is ok, but on this one i have some problems... I'll try with another version of mysql as soon as I find some time!
Of course there are entries in my car table but it doesen't metter be cause I select nothing from that table?!
Well this works in MySQL version 3.22 (I think it,s .22 but it's 3 for sure ;) but it doesen't work with 4.1.18! Is there some changes in version 4 which I dont know or what?
TNX, that's what I was thinking: too complicated to make this if not nececcery! ;) I'll lost at least one day to implement this in my app.
I'll just let admin's to use phpmyadmin or mysqldump or whatewer they want to make a export/backup!
did you try to add this to your virtual table?
'select * from table1, table2'
Like this you select all fields from both tables and it should be OK!
Or I didn't understood your problem well?
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...
Well I know all about MySQLDump and I use it often... But not now! ;) I'm developing a client application running on windows which connects to remote MySQL server running on linux... I was thinking to develop automatic backup directly from my application but I think that's stupid cause it will...
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!!!
OK I find out something, memo field allows me to enter as menu char's as it exists in bigist field in DB... SO I enter a lot chars in one row, so now I can enter more chars in my memo field! How to disable this, or how to manualy enter no of chars in my field (TTable I quess?!)
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.