Hi!
Get the SQL statement of the view and find all '?'. Well, a bunch of processing is required because view accepts parameters like 'alias.Fieldname' or 'object.object....object.property'
Instead of CREATEOFFLINE, I would suggest you to use COPY TO command and copy data into the table, than add fields to track changes in that table. When going online and updating the main database, use these fields for tracking changes to update data on the server. This way you can also track the collisions that is not available for offline views. More reliable and no problem with parametrized views. Well, this require to make your own data handling class that will be aware of the offline state and store required information about changes...
>Hi, all.
>
>I hope my question isn't too obscure to understand. I know what I need, I'm just not sure I'll frame the question correctly.
>
>I need to determine, from within a program, whether a view is parameterized. More to the point, I need to determine: (1) the list of parameters, (2) the types of parameters and (3) which operator is used with the parameter.
>
>It doesn't appear that DBGETPROP(cName, 'View', 'ParameterList') will give me what I need if the parameters are only "defined" in the filter/where, as opposed to being listed in the "View Parameters".
>
>But, I'm willing to compromise if there is another solution. :) I'm really only wanting to take views offline, and using CREATEOFFLINE() prompts me with the parameters. Since I'm trying to make this whole routine generic, I won't know in advance what views are present, which views are parameterized nor what the parameters are asking for.
>
>So, I either want to determine what parameters are required by the views, so that I can create them, open the view and not have the user fuss with the prompt. Or, I need to be able to somehow use CREATEOFFLINE() without being prompted for the parameters.
>
>Any suggestions?
>
>Thanks,
>
>-Bri.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.