that REPLACE INTO is an alias for INSERT OR REPLACE. Any one know why this failed?
REPLACE
sql-statement ::= REPLACE INTO [database-name .] table-name [( column-list )] VALUES ( value-list ) |
REPLACE INTO [database-name .] table-name [( column-list )] select-statement
I also tried using INSERT OR REPLACE INTO in an sql statement that was suppose to insert a user into a table if the user did not already in the table and it did not work. The error again was SQL error? If I just use INSERT in the sql statement it work, user is inserted into the table. Does know why INSERT OR REPLACE INTO does not work?
Steve
Cory Nelson wrote:
Try the UNIQUE keyword when creating your table..
On Tue, 25 Jan 2005 09:34:53 -0500, Steve Frierdich
<[EMAIL PROTECTED]> wrote:
Does anyone have any code they can send me that shows how to check for a string in a column in a table, and if the string is not there on how to insert the string in the column in the table in a new row. Then finally on how to update the table?
And if possible on how to maybe write a trigger for the above operation and use the trigger in a Visaul C++ or a Window's 32 program?
Thanks
Steve 727 455 4668 727-547-9799 ext 1766