Showing posts with label field. Show all posts
Showing posts with label field. Show all posts

Friday, March 23, 2012

MSQL Update

Hi
Can anyone help me with the MSSQL following problem:
I want to update the field "Date" with today´s date in a Tabel named Customers
I want to click on a "button" that runs something like:

Update Date with Today´s date where CustomerName = TextBox.text

Thanks in advance for your helpstring strSQL = "UPDATE [Customers] SET [Date] = GetDate() WHERE CustomerName = " + TextBox.Text

basic, basic, basic

Monday, March 19, 2012

msg 4866

I have created a tab delimited text file using MS Foxpro 2.6 for Unix.
The last field on each line is followed only by a linefeed \n.
When I try to use bulk insert I get the message that the 40th (last) field on the line is too long.
I have tried adding a tab after the last field but this makes no difference.
I have added an ! (exclamation mark) after the last field and changed the rowterminator attribute to !\n. Still doesn't work?
I am using sftp to copy the file from the unix system to windows, and there is no change in the size of the file, so I don't think that a carrriage return is being inserted.
Any suggestions?

If I reduce the size of the input file to one record, then the insert works.|||Never mind, I figured it out. Lines have to end with '\r\n' regardless of the fact that the documentation says the default ROWTERMINATOR is '\n'