Search results for query: *

Hi Craig, Thanks for your reply. I looked the article written below (URL at the end) and noticed you 're also passing the recordset sameway unless I 'm looking different one. I 've copied below lines from your Article. * Get a reference to the DatabaseTable object for table...

Hi Craig, Please see the code below. Thanks! G. lcReportFile = "ReportTest.Rpt" oCrApp = CREATEOBJECT("CrystalRuntime.Application") oCRpt = oCrApp.OpenReport(lcReportFile) oDbObj = oCRpt.Database() oDbColObj = oDbObj.Tables() oDbTable1 = oDbColObj.Item(1)...

Mike, Thanks for your reply. My client 've already designed the report with the ttx definition file and asked me to create the same thru the prog. I 've created so many other reports also like this but only difference this has parent and child table relation. My curiosity...

Yes,I 'm creating recordset from fox tables. I 've created a crystal report on the basis of ttx definition file. There're no setting like set exact or set deleted and I confirmed recordset has the data by printing message. Mike, I 'm binding this report with the ado recordset data...

Hi, I 've created ADO Recordset and passed that to a crystal report. It works fine when I 'm in the development mode and shows me the report preview fine. But when I compiled that to executable,I don't see any data in the report with the same selection criteria. I 've put messagebox to see...

Hi Mike, Sorry ,I was sick and did n't get to work. Yes, you are a wonderful help and this is very useful too. I think why I did n't want to use ADO were because of the "DLL hell" and I was reading somebody's conversion notes from VFP to Sql server that there are some problems with Dll...

Mike, Thanks for your help. When I will be doing this on Sql server how I could tell the stored procedure that results are already there and only thing is get me the next records from the last pointer. My Regards to you!! Gurvinder.

Hi Mike, Thanks for your reply. I think you are right if you 're dealing with small data. but why I 'm thinking other way is that in Client server environment what if my query matches 10,000 records and I don't want to bring all on the client side just read few records by user's input...

I 'm new to Sql Server and would like to know that how you can create a cursor on the server side and then how you can move forward or backward on that cursor by either reading 1 or group of records. I 'm using VFP as my front end. Actually I don't want to use ADO's onto this. I 'll be...

Hi Atul, I just did a work around it and that got fixed the report but my problem was that I had something in group footer and that was causing that problem to resolve that I created another group band by giving recno() as Group and move everything from group footer to the group header...

Mike, Thanks much for your help. I found later there is backcolor and foreColor property in the tree control. Please see code below. e.g. #define CHILD_NODE_LOC 4 *** Add a node oNode = Thisform.oletree.Nodes.Add(ALLTRIM (cParentid),CHILD_NODE_LOC,ALLTRIM(cKeyid)...

Rick, Sorry, I did n't know the policy here but I thought sending report would help identify problem easily. Extra page it prints is blank and it is happening when report has only one page and there are no UDF's used in this report but most of the report is based on the memo fields...

Hi Rick, Thanks for replying and if you could send me your email address then I could send you my report and dbf file to review. I ts happening on all of machines and every machine has same Win 2000 O/S too. Thanks!!! G.

Juris, Thanks for replying. Do you 've any code example which I could use?

I would like to know, if any dynamic coloring facility is available in Microsoft's tree control.

I 'm having some problem in Foxpro 8 report which seems to be working fine in Foxpro 7. It is throwing an extra page in Version 8 and if you use same report in Foxpro 7 it prints fine.

Rick, Thanks for the additional code as I'm going to add all in my library and now it is much more clear now. You and Aircon been such a great help for me and I appreciate that. Well now everything is working fine then I noticed Foxpro's FOPEN() does n't support shared files. Do you guys...

Dear Aircon, Thanks much. Is this going to work for both short and Long Integers? Regards, Gurvinder

Rick, Thanks for the tip. I just need to ask you or Aircon about the reverse step of this because when I need to right this value back to the file the I need to convert value of Integer to Binary again. Thanks again. Regards, Gurvinder.

Dear Aircon, It was a 32bit signed integer and your code worked fine to convert that. I appreciate all of your help and Tek-Tips sight. Thanks to Rick also. Gurvinder [2thumbsup]