Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding table in the dataenvironement by programation
Message
From
03/08/2000 11:37:07
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00400288
Message ID:
00400397
Views:
21
Benoit,

Give this a try it might help. In your routine store the alias of the table or view in use to a parameter before you execute the code below. After the "USE" statement below select the alias stored. FoxPro must have a table or view selected when executing commands with the report, whether that report uses that table or view does not matter only that one is selected. It appears the "USE" executed will leave the program in a state where no table or view is selected.

HTH
John

>Hi All
>
>I have a application that generate report. The report can be modify by the user.
>
>Before the user can modify the report I append a record in the .frx
>with these information.
>
>Use ReportName Exclusive
>
>Append Blank
>
> Replace Platform With "WINDOWS"
> Replace Objtype With 26
> Replace Name With "cursor"
> Replace Expr With 'Left = 10'+chr(13)+;
> 'Top = 20'+chr(13)+;
> 'Width = 95'+chr(13)+; 'Height = 90'+chr(13)+; 'Alias = "test"'+Chr(13)+;
> 'CursorSource = ..\data\test.dbf'+chr(13)+;
> 'Name = "Cursor1"'
>
>Use
>
>When I try to do
>
>Modify Report ReportName Save
>
>A message pop up telling me that the cursor can not be fond.
>If I add the table using the report generator and after I look the report as a table, that is what I see in the Fields
>
>Platform Field
>WINDOWS
>
>Name Field
>-----------
>Name = "Cursor1"
>
>Objtype Field
>-------------
>26
>
>Expr Field
>----------
>Left = 10
>Top = 20
>Width = 95
>Height = 90
>Alias = "test"
>CursorSource = ..\data\test.dbf
>
>It look the same for me !
>
>Any tips ?
>
>Benoit
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform