Hi Faruk,
>a. Data Entered from a textbox of a form or directly in browse mode in a remote view connected with a table of sql server database reflects that the SQL Server Database contains Blank Spaces with a ASC II Charecter (Square Charecter).
>
>Eg: x="Faruk Hosain "
>
>SQL Server Table Reflects "Faruk Hosain " + a square charecter.
>
>Please tell me How to remove the blank space and the Square Charecter.
It has been a while since I had this problem, but if memory serves this may do the trick. Make sure the field you are linked to in SQL is using char and not varchar. I have had some problems using varchar in SQL with VFP. If you really want to have a varchar field in SQL you may want to use text instead.
>b. How to connect a memo field (VFP) with a SQL Server Text column. It does not work in a remote view...
If you are using the view designer for your remote view, go to the menu bar select query and then advanced options. Make sure the fetch memo box is checked. Also be sure that you use an edit box instead of a text box in VFP for memo fields. If you are using SQLEXEC to get the remote data be sure to turn on memo fetching before getting the data. CURSORSETPROP('fetchmemo',.T.,0)
HTH
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement