Did you rebuild the Wizard? If you didn't it'll use built in table.
>already tried to do this by appending a record in the typemap.dbf
>
>localtype = C
>Fulllocal = character
>Remotetype = uniqueidentifier
>Varlength = T (also tried with F)
>Hasprec = F
>Server SQL Server4x
>
>Put the GUID's in a c(36)-field in Fox, but still can't chose uniqueidentifier in the wizard. The GUID's seem to be fine, have manually changed field type on the SQL-server. Tried to help me now by using the following:
>
>
>
>* cursor curTab holds als the files to update
>lcConn = "DRIVER=SQL Server;SERVER=(local);APP=Microsoft Visual FoxPro;WSID=DELLI;DATABASE=testdb;Trusted_Connection=Yes"
>lnConnHandle = SQLSTRINGCONNECT(lcConn)
>
>SCAN
> lcSql = "alter table " + RTRIM(Table_name) + " Alter COLUMN " + RTRIM(field_name) + " uniqueidentifier"
> lnRes = SQLEXEC(lnConnHandle, lcSql)
> IF lnRes != 1
> WAIT WINDOW "Error with table " + RTRIM(table_name)
> ENDIF
>ENDSCAN
>
>
>
>Using the wizard directly would be much more elegant. Any ideas how to achieve this?
>
>TIA
>-Dieter from Muenster, Germany
--sb--