phpbar.de logo

Mailinglisten-Archive

dbExpress - inserts

dbExpress - inserts

Manuel Dugue mysql_(at)_lists.phpcenter.de
Thu, 13 Sep 2001 09:22:47 +0200


This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C13C35.A76398A0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Hi everyone,
Wir portieren ein ADO/ MSSQL Projekt zu dbExpress/ MySQL in Delphi.

Die Tabelle sieht so aus:

ID int primary key auto_increment
Name char(255)

Wir haben Befehle wie folgt:

SQLClientdataSet.append;
SQLClientdataSet.fieldbyname('Name').asString := 'test1';
SQLClientdataSet.post;

jetzt kommt bei jedem ausführen des Befehls die Fehlermeldung 'ID mußt have
a value'.

Jemand eine Idee, wie man das lösen kann?

------=_NextPart_000_000B_01C13C35.A76398A0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial size=3D2>Hi=20
everyone,</FONT></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial size=3D2>Wir =
portieren ein=20
ADO/ MSSQL Projekt zu dbExpress/ MySQL in Delphi.</FONT></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial size=3D2>Die =
Tabelle sieht so=20
aus:</FONT></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial size=3D2>ID int =
primary key=20
auto_increment</FONT></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial size=3D2>Name=20
char(255)</FONT></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial size=3D2>Wir =
haben Befehle=20
wie folgt:</FONT></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D775121607-13092001><FONT face=3DArial=20
size=3D2>SQLClientdataSet.append;</FONT></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><SPAN =
class=3D775121607-13092001><FONT=20
face=3DArial size=3D2>SQLClientdataSet.fieldbyname('Name').asString :=3D =

'test1';</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><SPAN =
class=3D775121607-13092001><FONT=20
face=3DArial size=3D2>SQLClientdataSet.post;</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><SPAN =
class=3D775121607-13092001><FONT=20
face=3DArial size=3D2></FONT></SPAN></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D775121607-13092001><SPAN =
class=3D775121607-13092001><FONT=20
face=3DArial size=3D2>jetzt kommt bei jedem ausf=FChren des Befehls die =
Fehlermeldung=20
'ID mu=DFt have a value'.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=3D775121607-13092001><SPAN =
class=3D775121607-13092001><FONT=20
face=3DArial size=3D2></FONT></SPAN></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D775121607-13092001><SPAN =
class=3D775121607-13092001><FONT=20
face=3DArial size=3D2>Jemand eine Idee, wie man das l=F6sen=20
kann?</FONT></SPAN></SPAN></DIV></BODY></HTML>

------=_NextPart_000_000B_01C13C35.A76398A0--

---
!!NEU!!
Fragen und Antworten zu MySQL und dieser Liste unter
-->>  http://www.4t2.com/mysql 



php::bar PHP Wiki   -   Listenarchive