Re: Writing a GUID to a SQL table

Tech-Archive recommends: Fix windows errors by optimizing your registry

> Where's the closing single quotation mark?

And the closing bracket???

It's there in the code.....


"McKirahan" <News@xxxxxxxxxxxxx> wrote in message
news:3dedneY_zeqJVizenZ2dnUVZ_sednZ2d@xxxxxxxxxxxxxx
> "Phil Kelly" <phil.kelly@xxxxxxxxxxxx> wrote in message
> news:uTUMhqzCGHA.2040@xxxxxxxxxxxxxxxxxxxxxxx
>> INSERT into tbl_accounts(fld_firstname, fld_surname, fld_address1,
>> fld_address2, fld_city, fld_county, fld_postcode, fld_country,
>> fld_accountGUID) VALUES ('Firstname', 'Surname', 'addr1', 'addr2',
>> 'Bury',
>> 'Lancashire', 'BB11BB', 'GB', '{1E0E9020-8025-4A11-8B8A-DF2F29882054}
>>
>> Which I assume tells me that the INSERT statement is not correctly
>> terminated - but looking at the code it seems to be???
>
>
> Where's the closing single quotation mark?
>
>


.