Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. strucnjak79

    How to save recordset in a txt file and read it later?

    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?
  2. strucnjak79

    Row cannot be located fro updating error

    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...
  3. strucnjak79

    Strange problem?!

    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...
  4. strucnjak79

    MySQL bug or just I'm stupid?!?

    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...
  5. strucnjak79

    How to backup mysql DB from delphi?

    I need to backup a mysql DB from my delphi app! MySQL DB is on remote server running on linux! Does anybody know the way to do this?
  6. strucnjak79

    Is there a query to export whole DB?

    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!
  7. strucnjak79

    MEDIUMTEXT from mysql delphi recognize as 'string'

    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!
  8. strucnjak79

    myODBC and remote MySQL server: password problem

    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...
  9. strucnjak79

    Empty field check?

    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!!!
  10. strucnjak79

    memo field problem?!?

    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...
  11. strucnjak79

    need procedure to enter 50000 records in DB table...

    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...
  12. strucnjak79

    2 fields combination unique in table...

    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...
  13. strucnjak79

    Passing argument?

    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...

Part and Inventory Search

Back
Top