Search results for query: *

hi! its been a long time.. 1) i want to learn building client/server app. but i dont have sql server for testing.. can i use the native vfp database? do i have to create a DSN to connect? 2) i noticed that in vfp, a DSN is required to connect to sql server. given the location of the sql...

hello! i can run my reports designed in crystal report within visual basic without any problem.. is there a way for me to generate my reports in visual foxpro using crystal report? any help to start with this idea will be highly appreciated. thanks!

hello! how can i directly output the resultset from a query into a table? processing the following lines creates a recordset in my computer's memory, I think.. cn.Open ConnectionString Set rs = cn.Execute("Select * from MyTable", , adCmdText) thanks!

hi everyone! I use this line in vb6 to pass a parameter value to a crystal report crpBcclaims.ParameterFields(1) = "parPayee;" & rs!payee & ";true" but how about passing parameter to a subreport??? :) cheers!

hi everyone im back with my new problem.. i have these records.. fld1 fld2 fld3 CCC 001 00 CCC 001 03 CCC 001 02 BBB 003 00 BBB 003 01 AAA 002 00 AAA 002 01 AAA 002 02 i need to group these records so it would look like this AAA 002...

my records look like this: fld1 fld2 Countries AA USA AA Japan AA Australia AA Cities BB New York BB Tokyo BB Sidney BB my report must be grouped by fld2. skip the first record when the group has changed because the first record in the group will be used as header. it should look...

hi there. After opening a text file, is it posible to ignore the comma-delimiter and assign the whole line to a single variable? Input #1, MyString where MyString should be "Smith, John 12335,12654,132Z" what happens is that MyString will only have "Smith" thank you...

It looks like my common dialog could not handle at least more than 15 files. When i inspect the .filename property of the common dialog control, it has this value: "c:\Temp\À”ü¿$…" If i select only few files, 3 or 10, no problem. I kept trying but i really got no idea why this happen...

using ado, how should i explicitly lock a certain record before editing it so other users will not be able to edit the same record. is there a function that would place lock a record on a record and will return a value if the lock is successful? as an example, i'm using msaccess database and i...

is it possible to implement transactions in msaccess? hope someone could tell me where to start. thanks.

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestDB.mdb;Persist Security Info=False" Set rs = cn.Execute("Update WTable set WRemarks = " & txtWRemarks.text", , adCmdText) WRemarks is a memo field. txtWRemarks multiline property set to True. This will return an...

i've created an odbc data source to connect to my old foxpro database and wrote a small program in vb that uses this data source. but when it finds that a date field is empty or has no value, it gives December 30, 1999. how do i prevent this to happen? thanks.

hi, i'm actually populating a data control with certain records from a table by this code: With adodc1 .RecordSource = "Select * from MyTable" .Refresh End With when the process is too long, i have to display a progress bar so the user would know that the retreival is being...

can i create a new table using a recordset derived from another table? how would i do this? also, can i create a recordset derived from two or more tables where some fields from these tables are the same except for the data and the table name? thanks!

the formula goes like this: {ImpJobProcess.dateperformed} in {?BegDate} to {?EndDate} and ((if not isnull({?parProcess1}) then InStr(uppercase({ImpJobProcess.process}),uppercase({?parProcess1}))<>0) or (if not isnull({?parProcess2}) then...

my records are FIELD1 FIELD2 A AA A BB A CC A XX A EE A FF B DD B CC B XX B AA B BB there are two groups, A & B. I...

hi there! i have a group of records and created a subtotal on each group. but i still need to group those subtotals in specified order such as Group of subtotals that are less than 500 &quot;<500&quot;, &quot;500 - 1000&quot;, &quot;>1000&quot; any idea on this matter? thanks!

i'm printing only the group footer section of my report by suppressing the details section. is there a way that i could alternate the background color of group footers? i could only apply this technique on details section. . . thanks!

im using CR Developer 8.5 and i want to format a certain number whose value is 8.55 would be formated as &quot;8.55&quot; but if the value is 8.00 then &quot;8&quot; only. is there any direct function for this? thanks.

hi! i just want my report to look like this. . . Customer1 Peter apple 50 Paul grape 35 Mary banana 10 ----- apple,grape,banna 95 Customer2 John orange...