Recent content by simco

Hi Which version of Crystal Reports is working with Business Objects 6.5.? Can this version of Crystal work with a Universe as a data source? Thanks SS

Hi All Which version of Crystal Reports is working with Business Objects 6.5.? Can this version of Crystal work with a Universe as a data source? Thanks SS

We are currently running BO 6.5. Is there a way to upgrade some of the licenses to XI and still keep the current 6.5. version for the rest? We need the XI for testing/demo purposes, to asses an upgrade. Any input is appreciated. Thanks. SS

Is it possible to use a table type variable to store the result of the first select? If yes, how? thank you

Oh yes, thank you. I considered this, but (I forgot to say, my mistake), I have a lot of Update (like more than 20) statements that use the same condition (where IF_Field in....). I would like to run the first select only once and then use it for each Update.

Hi all, I want to do something like: SELECT ID_Field from STable where [here comes a long list of conditions that I need to build dynamicaly] Then I want to be able to say: Update DTable set Field='Value' where ID_Field in (here I want to put the result from the above select). (all the...

What if the Select statement looks like: "SELECT field1 from table1 inner join table2 on table1.id=table2.id group by field1" and I need to restrict both table1 and table2 values. (adding it to the end is going to cause an error in this case) See, that's my problem, it has to work...

Hi, I am trying to dynamically add a where clause to any existing SQL SELECT statement (any SELECT that comes from the user). The purpose is to allow them to select only the records flagged in a certain way. And, since the flag field is the same in all tables, I was thinking that a solution...

Thanks for reply. UPDATE would be a good solution. In the case presented above, I guess I was just trying to find out if FoxPro allows the use of CursorSetProp and TableUpdate to a cursor based on other cursors and not on the actual server tables. Thanks again P.S. I would paste the code...

Hi all, I retrieved data from a remote data source using SQLEXEC and I created 2 cursors. Now, at some point in my code I use these 2 cursors to create a third one. Than I want to make the third one updatable using CursorSetProp, but I get an error message: "Property is invalid for table...

You are on the right track. Let's say that your form is called Form1, and 1st combo box is Combo1. When you create the query in the query designer, just write in the Criteria (for the field that is going to be the displayed in the 2nd combo box) Form1!Combo1.value. Then save the query and use it...

Thanks everybody!

Nobody? Any tips will be appreciated! Thanks again!

I am interested in any opinions you have regarding these 3 methods of retrieving data. Especially the new CursorAdapter from Visual FoxPro 8.0. Thanks a lot! :-)

Did you compact your database? If no, do so (go to Tools/Database Utilities/Compact Database). :-)