Recent content by DriesM

Just one final remark. By defining an identity column I had to reserve at least one position for it. So I lose the left most character of every record. And even that was only possible after altering the format file manually. By default bcp chopped the four left most characters (type int)...

Frederico, I didnt think an identity column would work, but some changes in the format file did the job. when i retrieve the records afterwards without specifying order by, the id's are still mixed up. Starting with id 5933, 6017, 6101... finishing with 5932. But ordering them by id, they look...

thx mrdenny, but sorry no index at all. The funny thing is that sometimes the order is correct, but most of the time it isn't, at random. Some more details: There are 3 different levels of records in the text file, that's why the order is important. The text record length isn't fix. Fields...

Hello, I us bcp 8.00 in a few vbs scripts to import a txt data file into an sql table. After running one specific script the records are stored mixed up in the sql table. The table is single column only containing one char field. How does one control the record order by useing bcp? Other...

Only Wep-key is active. Besides connection isn't the problem. Obtaining an IP address is what this is about.

No hosts file, still no IP.

I installed a Level One WLAN card in a old win98 pc. When running the WLAN tool it shows that there's a connection with the Siemens Santis 50 router. The routers web tool also shows the pc as a wireless client. But it doesnt hand out an automatic IP address. My laptop connects via Bluetooth...

and yes: textboxtext should have been RICHtextboxtext in line 1&5 but that's beside the problem. Driesm

Hello, I have this problem with a richtextbox, wich I use to create a chat client control in VB6.0. I want to add colors wich are included in the incoming data stream. But everytime a colored text is added, it loses his color property when the next text (=sentence, word or even character) is...

That's how I created the macro in the first place.

Hi Geoff, I can use 1. "csv seperated by listseperator". (in dutch: lijstscheidingsteken) but it's the default seperator in Windows. 2. "csv os/2 or MS-DOS" In both cases the semicolumn is used. Dries.

Hello all, I have this macro who has to save an .xls file into .csv format. This macro is attached to a button. Private Sub BTNopslaan_Click() ActiveWorkbook.SaveAs FileName:="F:\alain\DEBVAL.CSV", FileFormat:= _ xlCSVMSDOS, CreateBackup:=False End Sub It does the...

Hello, I'm a FPD programmer since many years. I've recently developped a new 2.6-app for Win98 users on a NT4.0-Lan. (yes some people still do that) Now i have this problem with tmp-files: Sometimes it happens that a client generates a huge tmp-file (> 1GB !). I'm pretty sure that it has...

The "enabled" property has (by default) .t. for all data-fields. That doesn't seem to help.

I find it weird. I dont see any "disabled" property. There's only have a "DisabledBackColor" and "DisabledForeColor" property. They obviously don't contain a boolean, but a color value.