Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a VFP7+SP1 BUG ?
Message
From
19/10/2003 11:50:43
 
 
To
17/10/2003 04:06:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00838754
Message ID:
00840107
Views:
23
Cetin
i have found my mistake and i want to apologise for wording it as a BUG. The mistake which i did was - that by mistake i had included the WORLD.DBC in the project and i was continuously compiling the EXE with the included DBC.

This has definitely taught me to look at the bugs more seriously.Now my project is working Ok and no complaints too !!



>Cetin
>
> Ref. to my firstoo message thread again.
>
> Cetin after reinstalling WINDOWS + VFP on my machine i havent tested this problem but i will surely do it today and will get back to you on UT .
>Thankyou for discussing this topic, it is helping me to see things which were a little murky.
>
>
>
>
>>Over the network it'd fail naturally if exe is local. That pathing is a relative pathing. ie:
>>set path to data
>>means set path to 'data' folder under current folder (which is typically the exe 'start in' folder - users might fix it themselves changing the start in folder to server's app folder).
>>
>>set path to \\myServer\myFolder\Data
>>
>>would explicitly set path to server's data path no matter the exe is and 'start in' folder is set to.
>>However if form's used DE and there is a data folder that matches developer's pathing then tables from that folder would be used no matter the pathing is. ie:
>>During development you had a c:\MyApp\Data folder and tables were used from this folder. In delivered box also there is a folder 'c:\MyApp\Data' with tables in it (test install or something like that). In that case no matter the pathing is forms use c:\MyApp\Data tables.
>>
>>Cetin
>
>
>
>>
>>>Hi Cetin
>>> The Database WORLD.DBC and its tables are all in the DATA folder.
>>>The pathing given by me in the APP is
>>>
>>> SET PATH TO temp;progs;DATA;reports;FORMS;MENU;libs;CURSORS;pics;DLL
>>>
>>>over the network this path fails. (look at the err msg below it references the client machines C Drive for the data)
>>>
>>>all this works fine on the APPLICATION SERVER but it gives the error when u try to run the app from the client machine. Last night i have reformatted my hdd and re-installed windows and VFP7 without the sp1 patch, i havent tried running the app on the new installation but will let you know when i have done.
>>>
>>>
>>>
>>>
>>>
>>>>>Hi
>>>>>
>>>>> I have a stange problem and i figure this could be a BUG (not sure).
>>>>>
>>>>>Earlier I had put the problem on UT but i didnt get satisfactory reply and I havent seen this problem being posted on UT.
>>>>>
>>>>>Following is my machine configuration -
>>>>> W2K Adv Server with SP4 installed.
>>>>> VFP 7.0 With VFP70SP1.MSP + VFPODBC.MSI
>>>>> CR 8.5 with SP1
>>>>>
>>>>>
>>>>>Following is my network application setup -
>>>>> Machine A (NETBIOS name of the machine is SRV) - Main application Server . The application database (WORLD.DBC) with the tables is installed in the share WORLDAPP
>>>>>
>>>>> CLIENT MACHINES - are configured to start the application locally on their machine but the database is accessed across the network via the following path \\SRV\WORLDAPP
>>>>>
>>>>>The problem i face now is that when the application is started from a client machine the following error is popped to the user (this never happened to me before applying the VFPSP1)
>>>>>
>>>>>*------------------------------------------------------------------------------------------
>>>>>c:\WORLDAPP\Data\WORLD.DBC : Cannot Link tabe '\\... \database\user.dbf' to this database:
>>>>>duplicate or missing fields. Would you like to try to locate the owning database or
>>>>>delete the link (and free the table)?
>>>>>
>>>>> LOCATE DELETE CANCEL
>>>>>*-------------------------------------------------------------------------------------------
>>>>>
>>>>>
>>>>>If i configure my client machines to work in the following manner than the app works fine and there is no error reported.
>>>>>
>>>>> CLIENT MACHINES - are configured to start the application on the server
>>>>> TARGET : \\SRV\WORLDAPP\WORLD.EXE
>>>>> START IN : \\SRV\WORLDAPP
>>>>>
>>>>>
>>>>>Another interesting thing is this only happens with the DATABASES i have created on this configuration (VFP7.0+SP1+VFPODBC.MSI). My earlier applications works fine and doesnt show any backlink error (possibly bcoz i had not applied vfp70sp1.msp patch).
>>>>>
>>>>>Does anybody have a similar problem !
>>>>
>>>>Sanjay,
>>>>I've been working with VFP7+SP1 almost since its release. I've never seen such a problem.
>>>>I suspect it's your pathing.
>>>>In your message :
>>>>
>>>>"c:\WORLDAPP\Data\WORLD.DBC" shows as database but .dbf is from another path. Probably during development you had the data in 'data' folder and form DE's now find a world.dbc from a 'data' subfolder. Try renaming the data folder to something else (ie:datax).
>>>>Cetin
Sanjay Dhiraj Patel

MCSE, MCDBA

Net2Biz (Thailand)
Previous
Reply
Map
View

Click here to load this message in the networking platform