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!

Register Log in
  • Congratulations Rhinorhino 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. gjcarrillo

    Access 2003 Insert Into Problem

    Regards Frederico, I have found a solution for the problem and I have fixed it atlast. The problem was actually in the database, in the options and in the tab tables/queries, it should be marked with the option "SQL server compatiable sintax (ANSI 92)". I hope that this thread is usefull for...
  2. gjcarrillo

    Access 2003 Insert Into Problem

    Cordial regards, Frederico Fonseca I have used all your suggestions and I obtained the same error. I would like to know, if it is possible for me to send to you the database design and the project,through your website. If you have any other ideas on any changes in windows xp settings or access...
  3. gjcarrillo

    Access 2003 Insert Into Problem

    Thank you very much 3GM, The error has been fixed, but the problem persists. TO fredericofonseca, The problem, is generated by inserting a value in the field (DateIn)and executes the WRITERECORD method, on the other hand if I omit the field (DateIn) in the selected fields in the database, the...
  4. gjcarrillo

    Access 2003 Insert Into Problem

    Receive my excuses fo the lack of information. My database is composed of three fields: Installer:Text, Code:Numeric and DateIn:Date The test Program is: ENVIRONMENT DIVISION. DATA DIVISION WORKING-STORAGE SECTION. 01 returnvalue pic s9(9) comp-5. PROCEDURE DIVISION. INVOKE...
  5. gjcarrillo

    Access 2003 Insert Into Problem

    I am programming in Windows XP with powercobol 7 to add dates in a data base Access 2003 and when I execute the WriteRecord I obtain a syntax error in sentence INSERT INTO. Somebody podria to help me with this problem?

Part and Inventory Search

Back
Top