Diese Seite mit anderen teilen ...

Informationen zum Thema:
WinDev Forum
Beiträge im Thema:
Erster Beitrag:
vor 4 Jahren, 9 Monaten
Letzter Beitrag:
vor 4 Jahren, 9 Monaten
Beteiligte Autoren:
Arie, Viggo Poulsen

WD17 - mssql tables get FIC extension

Startbeitrag von Arie am 26.09.2013 19:33

Currently I'm using HFCS for one of my applications. All files are defined as hf-classic in de analysis. At runtime I set the connection parameters to a hfcs database. So far so good.
Now I'm trting to switch the connection..provider option to SQLOLEDB and the required user and password and so on.

Now when I create all the files with HCreationIfNotFound(filename) SOME of the files are creates with a .FIC extension, like dbo.database1.customers.fic. While other tables are fine, like dbo.database1.orders

I must be overlooking something, but I don't see any difference in the analysis. (there I see an extension property, but is holds .FIC for EVERY file)
Also when I generate the SQL-script, some of the file are OK. And others have .FIC

What am I missing?


Hi Arie

When looking at your datafiles description, are you sure they all use the same connection ? In one of my projects I have a connection for my local pc, and another for my cloud server. Strange things happened when I changed all but one.

Best regards
Viggo Poulsen

von Viggo Poulsen - am 26.09.2013 21:08

Re: WD17 - mssql tables get FIC extension SOLVED

Solved and this is what I did.
In the analysis I changed the connection to OLEDB. Now the window of the filedescriptions changes a bit and shows me a field for "name of the table in the external database"
Here a lot of files had the .FIC extension and using the sme field I could remove them all.

von Arie - am 28.09.2013 18:39
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.