Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013

    Unanswered: I get 'Mismatch criteria expression' error...

    Hi we need to do a task at school and I have a register page where users can put in their info and from there it INSERT INTO my database. When I run the program and submit the info on the register page I get 'Mismatch criteria expression' error. Here is my code...

    procedure TForm1.btnskepprofielClick(Sender: TObject);
    sskryf, snaam, svan, swag, ssel: string;
    snaam := edtnaam.Text;
    svan := edtvan.Text;
    swag := edtwagwoord.Text;
    ssel := edtselno.Text;

    ADOQRY.Active := false;
    ADOQRY.sql.Text := 'INSERT INTO Gebruikers(Naam,Van,Wagwoord, Selnommer) VALUES ('''+snaam+''', '''+svan+''', '''+swag+''', '''+ssel+''')';
    ADOQRY.sql.Text := 'Select * from Gebruikers';
    ADOQRY.Active := true;

  2. #2
    Join Date
    Nov 2011
    That error generally means you are joining 2 fields with different data types.Check you field type(s) and be sure they are the same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts