I have a program which retrieves record from the SQL table. This is the program:
STORE SQLCONNECT('dbcsqllibrary', 'sa') TO lnConnHandle
IF lnConnHandle <= 0
MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
ELSE
MESSAGEBOX('Connection made', 48, 'SQL Connect Message')...
My group in the development team is evaluating ways by which we can retrieve records the fastest way. Our database is MS SQL and our programming language is VB 6.0. My question is which is faster in terms of record retrieval, SQL's view or programmatically bound a control's recordsource to a...
I have already finished my system with databases and tables defined in VFP meaning the *.dbf and *.dbc files. I was told by my superior to migrate it to MS SQL. I don't have experience yet in this implementation. All I know is to connect through remote views. But how can I reference to these...
How can I connect to MS SQL using DAO if it does not have ODBC? I already have finished coding the app using DAO on MS Access tables. But my boss told me to migrate my databases to MS SQL. How can I do that with DAO?
I am currently migrating MS access databases to MS SQL. I have a field with a decimal data type in MS Access with a field length 16 and 2 decimal place values (values after the decimal point). How is this converted in MS SQL if Decimal data type has a maximum field length of only 9? I...
Sorry guys, but I need all the help I can get. I already posted this problem under the Microsoft VFP forum but I don't have response yet. Maybe guys here in this forum can help me. How can i attach my application menu (namely Transaction and Administration) be a part of the default menu of IE...
How can i attach my application menu (namely Transaction and Administration) be a part of the default menu of IE (e.g. File, Edit, View, Favorites, Tools, Help). I already made an activedoc class which calls my main.prg. My main.prg calls the menus created by the wizard. When I loaded my app...
I'm already finished with my application, having compiled it into an executable file. Now, my boss asked me if I could implement my application as browser-based so that user's can access my app through the internet browser. I read about Active Document application in the Visual Studio help file...
I've already finished my system and i'd like it to have it browser-based or internet-based so I can just have it posted on our intranet site. The problem is I haven't done this before. Anyone who could help me start this project? Thanks a lot. This forum really helps me.
Currently I am working with a library system. I've got a problem with regards to a view which is bound to a combobox. Let me cite 2 transactions which in effect have to 2 tables: Requesting of Titles to be Bought Transaction --> "tblRequest.dbf" and Title Quotation Transaction ->...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.