mariusseven
Last Activity: Apr 7 '09, 03:10 AM
Joined: Mar 28 '08
Location: Cebu City, Philippines
-
Use the Microsoft Visual Studio 6.0 Tools Package and Development Wizard to create a package file so that all the components and references that you used in your application will be included. -
The only thing you must have is
1. userid
2. password
3. ip of the server you want to connect to
4. and the database name...Leave a comment:
-
Create a query for that report, you can test it using a query analyzer. Then try to find a way to have a ttx builder. Then create a .ttx file and then create a report by choosing
>the Crystal Dictionary,
>then choose More data sources,
>then Active Data Sources,
>then Active Data (fields definitions only)
or you choose the other way directly choosing the database thru the
data source....Leave a comment:
-
I'll try that this one, but i am using a connection that is not System DSN type. Its a sort of I.P. based....Leave a comment:
-
That's the idea. Because i want to fetch data from the old db (which is the foxpro)...Leave a comment:
-
Post your code...plsLeave a comment:
-
The code i have made was the one that i have posted first, but i have no idea on how to connect the two......Leave a comment:
-
How to connect VB6 to a FoxPro database
I have this problem of connecting to a fox pro database. The system i am developing was a new one but the client wants to get data from the old database. Right now i am using VB6 as my front end and Ms SQL as m back end database. -
Thanks for the ideas. I'll try what you have suggested.Leave a comment:
-
I have also the same problem when using package and development wizard.
The error that appears is:
Unexpected error number 429 has occurred: ActiveX component can't create object.
Is there any way to fix this problem.Leave a comment:
-
Is that option available in Visual Basic 6.0 or only in newer versions? I have this idea of emptying the memory of the computer after every event, does this help?...Leave a comment:
-
About Error Handler
After a complete testing of the program created in VB 6.0 and no more error were found, should the error handlers be removed before compiling? -
Yes, its all about retrieving database files and storing them....Leave a comment:
-
Ways to Optimized Visual Basic Softwares
I need ideas of how to make visual basic programs perform faster without compromising its details and efficiency. -
i just want the query of both tables, i don't want them to join or merge. i want to query them using a single query with filters.
Its like i want to compare the total values of the first table cont to the range of the values of the second....Leave a comment:
-
Sorry for the late relpy..
here is the sample of tables....
table 1
Name......Cont1 ..... Cont2...... Cont3.....Cont4
Name1 .....100 ......200 .........300... ......400
Name2......500. ..... 600..........70 0.........800
Name3 ......900...... 1000........110 0 ......1200
table 2
Code ......%Cont ......ContA.... ..ContIN ..... ContFL
Code1 ...... 0 .............. 0 ...Leave a comment:
-
The data i need are from two tables that have nothing in common..is it impossible to create a single query on both of their fields?...Leave a comment:
-
I want to make only one query because i'll be using it to create a .ttx file of crystal reports to be used in vb6....Leave a comment:
-
A single query between two tables without link on its fields
SELECT
SUM (fieldname) AS T_Withheld
,SUM (fieldname) AS G_Income
,SUM(fieldname) + SUM (fieldname) + SUM(fieldname) + SUM(fieldname) AS Premium
,SUM (fieldname) - fieldnameC - (SUM(fieldname) + SUM (fieldname) + SUM(fieldname) + SUM(fieldname)) AS T_Income
,fieldnameA
,fieldnameB
FROM tablename A
GROUP
BY fieldnameA
,fieldnameB
,fieldnamec...
No activity results to display
Leave a comment: