Hi Marc,
Thank you.
This is what I needed: "Seek the ID in the dbf. If found, start a second loop as long as the ID = OLDID and change the data. Exit the second loop and process the CSV for next values"
It was the second loop that I was missing. This should run much much faster
Search found 21 matches
- Mon Dec 16, 2024 7:42 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Stuck - Database update via .csv file
- Replies: 8
- Views: 454
- Mon Dec 16, 2024 5:58 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Stuck - Database update via .csv file
- Replies: 8
- Views: 454
Re: Stuck - Database update via .csv file
Hi Otto :)
I can't just do an append.
I am updating a database with new ID numbers.
In the csv file, there is the old ID, new ID and name (22000 of them).
The csv file will only show 1 entry for each "old ID" however, there can be multiple entries in my database for the same "old ID".
I need to ...
I can't just do an append.
I am updating a database with new ID numbers.
In the csv file, there is the old ID, new ID and name (22000 of them).
The csv file will only show 1 entry for each "old ID" however, there can be multiple entries in my database for the same "old ID".
I need to ...
- Mon Dec 16, 2024 5:31 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Stuck - Database update via .csv file
- Replies: 8
- Views: 454
Re: Stuck - Database update via .csv file
The .csv file is a text file.
I can't just import the data, I need to update the data in the database based on the info in the .csv file
I can't just import the data, I need to update the data in the database based on the info in the .csv file
- Mon Dec 16, 2024 4:57 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Stuck - Database update via .csv file
- Replies: 8
- Views: 454
Stuck - Database update via .csv file
I need some help figuring out some data manipulation.
I have a database with 90000 entries.
I have a .csv file with 22000 entries.
In the .csv file there are 3 entries per line (cOld, cNew, cName)
I need to go through the .csv file and match cOld to my database filed MyDB->ID and cName in MyDB ...
I have a database with 90000 entries.
I have a .csv file with 22000 entries.
In the .csv file there are 3 entries per line (cOld, cNew, cName)
I need to go through the .csv file and match cOld to my database filed MyDB->ID and cName in MyDB ...
- Thu Apr 11, 2024 4:48 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
Perfect. Thanks all for the help. I was able to send myself an SMS
- Thu Apr 11, 2024 4:02 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
scratch the last message.
I forgot to update libcurl.dll
No errors now.
By adding this code, does it affect anything?
I forgot to update libcurl.dll
No errors now.
By adding this code, does it affect anything?
Code: Select all | Expand
#pragma BEGINDUMP
void __get_std_stream() {}
void _chdir() {}
#pragma ENDDUMP
- Thu Apr 11, 2024 3:59 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
I found this in the fourms...
#pragma BEGINDUMP
void __get_std_stream() {}
void _chdir() {}
#pragma ENDDUMP
I added that and it compiles but when I run the program I get an error:
"The procedure entry point curl_mime_addpart could not be
located in the dynamic link library C:\Certus\CertusPIN2 ...
#pragma BEGINDUMP
void __get_std_stream() {}
void _chdir() {}
#pragma ENDDUMP
I added that and it compiles but when I run the program I get an error:
"The procedure entry point curl_mime_addpart could not be
located in the dynamic link library C:\Certus\CertusPIN2 ...
- Thu Apr 11, 2024 3:25 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
I've updated the harbour files and made the changes mentioned above.
Done to 1 error now:
Turbo Incremental Link 6.80 Copyright (c) 1997-2017 Embarcadero Technologies, Inc.
Error: Unresolved external '___get_std_stream' referenced from C:\HARBOUR\LIB\HBVM.LIB|fm
Error: Unable to perform link ...
Done to 1 error now:
Turbo Incremental Link 6.80 Copyright (c) 1997-2017 Embarcadero Technologies, Inc.
Error: Unresolved external '___get_std_stream' referenced from C:\HARBOUR\LIB\HBVM.LIB|fm
Error: Unable to perform link ...
- Thu Apr 11, 2024 3:05 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
Same errors if I add in xhb.lib
- Thu Apr 11, 2024 3:01 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
This is the code I'm trying to compile.
#include "FiveWin.ch"
#include "directry.ch"
#include "FileIO.ch"
#include "Common.ch"
#include "hbclass.ch"
#include "C:\Harbour\Include\hbcurl.ch"
#define ACCOUNT_SID "XxxxxxxxXxXXXX"
#define AUTH_TOKEN "Twilio-Acc-Token"
#define TEL_FROM ...
#include "FiveWin.ch"
#include "directry.ch"
#include "FileIO.ch"
#include "Common.ch"
#include "hbclass.ch"
#include "C:\Harbour\Include\hbcurl.ch"
#define ACCOUNT_SID "XxxxxxxxXxXXXX"
#define AUTH_TOKEN "Twilio-Acc-Token"
#define TEL_FROM ...
- Thu Apr 11, 2024 2:45 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
If I try with harbour I get these errors:
Turbo Incremental Link 6.80 Copyright (c) 1997-2017 Embarcadero Technologies, Inc.
Error: Unresolved external '_HB_FUN_HB_BLEN' referenced from C:\FWH1611\LIB\FIVEH.LIB|OLEFUNCS
Error: Unresolved external '_HB_FUN___OLEVARIANTNEW' referenced from C ...
Turbo Incremental Link 6.80 Copyright (c) 1997-2017 Embarcadero Technologies, Inc.
Error: Unresolved external '_HB_FUN_HB_BLEN' referenced from C:\FWH1611\LIB\FIVEH.LIB|OLEFUNCS
Error: Unresolved external '_HB_FUN___OLEVARIANTNEW' referenced from C ...
- Thu Apr 11, 2024 2:43 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
Re: compile errors
Hi Antonio
I'm using xharbour. Are there any libs for using curl with xharbour?
I'm using xharbour. Are there any libs for using curl with xharbour?
- Thu Apr 11, 2024 2:18 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: compile errors - send a SMS
- Replies: 19
- Views: 2162
compile errors - send a SMS
Hi all,
I'm trying to compile a sample of using curl with Twilio.
I've linked in hbcurl.lib, libcurl.lib and hbcurl.ch
I get the following errors. Anyone know what I'm missing?
Turbo Incremental Link 6.80 Copyright (c) 1997-2017 Embarcadero Technologies, Inc.
Error: Unresolved external '_hb ...
I'm trying to compile a sample of using curl with Twilio.
I've linked in hbcurl.lib, libcurl.lib and hbcurl.ch
I get the following errors. Anyone know what I'm missing?
Turbo Incremental Link 6.80 Copyright (c) 1997-2017 Embarcadero Technologies, Inc.
Error: Unresolved external '_hb ...
- Tue Feb 27, 2024 9:11 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Connecting to a BLE device
- Replies: 8
- Views: 857
Re: Connecting to a BLE device
Sorry Antonio,
Threw out my back and have been unable to test until now.
It would not compile. See below:
┌────────────────────────────────────────────────────────────────────────────┐
│ FiveWin for xHarbour 16.10 - Oct. 2016 xHarbour development power │▄
│ (c) FiveTech 1993-2016 for Microsoft ...
Threw out my back and have been unable to test until now.
It would not compile. See below:
┌────────────────────────────────────────────────────────────────────────────┐
│ FiveWin for xHarbour 16.10 - Oct. 2016 xHarbour development power │▄
│ (c) FiveTech 1993-2016 for Microsoft ...
- Wed Feb 14, 2024 2:33 am
- Forum: FiveWin for Harbour/xHarbour
- Topic: Connecting to a BLE device
- Replies: 8
- Views: 857
Re: Connecting to a BLE device
Do I need a certain version of FiveWin for this ?