Hi,
I have just started using V9 (although I have used 8 and 7 for about 3 years) and I am having a few problems with using a smart data object. I will use the sports database to illustrate my problem.
I want to create a smart data browser that will display 3 fields from the customer database table and two variables. I have create a smart data object using a freefrom query but I find that there does not seem to be away to add variables into the fields list or anywhere in the smart data object. I believe if I create the smart data object using a temp-table like the database table I can add variables to this temp-table. Is this the best way to go?
What I want to do is display values in the two variables from an outside program that does all the calculations once I pass it the relevant details from the customer table. Do all of these calculations need to be done in the smart data object or in the smart data browser. Am I even using the correct smart objects to go about doing this.
Any help is greatly appreciated.
Thanks.
I have just started using V9 (although I have used 8 and 7 for about 3 years) and I am having a few problems with using a smart data object. I will use the sports database to illustrate my problem.
I want to create a smart data browser that will display 3 fields from the customer database table and two variables. I have create a smart data object using a freefrom query but I find that there does not seem to be away to add variables into the fields list or anywhere in the smart data object. I believe if I create the smart data object using a temp-table like the database table I can add variables to this temp-table. Is this the best way to go?
What I want to do is display values in the two variables from an outside program that does all the calculations once I pass it the relevant details from the customer table. Do all of these calculations need to be done in the smart data object or in the smart data browser. Am I even using the correct smart objects to go about doing this.
Any help is greatly appreciated.
Thanks.