Hi,
I am trying to create an sql remote view from an sql server... this part is ok, but is there a way for me to check the state of the fetch??
You see, when I create a remote view programmatically the code runs smooth, but I need to know if all records has already been gathered or if the code...
Thaks for the replies guys...
I decided that I will just have to make a Maintenance code that will make all deleted records permanent at the end of the day, or after closing hours..
Hi,
I have a program that uses tables which is shared with other users, the dilemma is this, whenever I delete some records, using the SQL Delete From which also uses Transaction, and Tableupdate, the records are successfully deleted.... that's what I thought...
But if I check the actual...
I have used the Microsoft Status Bar as part of my form, i can easily manipulate the panels...
However, when it comes to manipulating the text properties such as the colors or font, i cant find the properties to manipulate....
has anybody tried using the status bar activex???
Hi Tia,
I am also designing a new system that would handle both online and offline scenarios.
So far, in design you need to visualize everything, from online scenarios to offline, how would the system function when it is online and how the system would detect the online situation then mode to...
Sorry about this one, I am a bit ignorant with regards to manipulating Excel objects and its automation...
what I am trying to achieve is read from the excel file and then terminate read after reading the first blank row...
assuming that I have test.xls as the text file, the excel file will...
Hi Rick,
Yup, have the modem installed and knows the COM port being used, I even switched ports to try the sample codes but no luck.....
Just to be sure, I tested the modem using the dial-up to connect to the net and the modem is good....
I have been pondering on this service for quite some time now, not really giving it too much attention since I dont really need it back then, but now I have to figure out how to invoke or run the dial up from a certain part of my program.
Is there a way that i can call the dial up from my...
hey Rick, thanks for the clarification..... fortunately I now remember how to invoke it, just needed some refresher...
a star for your time and effort...
Hi Rick,
with regards to the connection, does it differ if i were to use ADO or ODBC connection??
with regards to the parameters that you have stated above, the 'activeusers' - is this the name of the table where the records are supposed to be extracted from??
ok, here is another dumb question.... how can I execute a SQL stored procedure with a parameter??
the stored procedure is in the SQL server database and not the ones in the .DBC
Hi, I am currently stuck in this situation where I am running a remote view to one of the SQL servers in our workplace... because of its proximity there are times that the query takes some time and at other times its quite fast maybe because of the number of records being extracted at a given...
Thanks Mike and Craig...
Craig - unfortunately this will be an ongoing process and not a one time deal only....
Mike - Good thing, the file that will be copied into another format doesnt have any indexing or memo fields involve..
will try your suggestion and get back to you...
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.