Recent content by madhatter2002

I have these views created for the SQL data. For some data that is not that big, data fetch is fast making the view accessible. However, there are cases wherein the number of data is really big, and I get the busy notification. Is there a way to detect if the view is still fetching so that the...

Is there a way to programatically create a data session or a data environment?? For example, we have 5 tables Table 1 Table 2 Table 3 Table 4 Table 5 and we have 3 forms, and 1 main form that can call the 3 forms. Form1 will use table 4 for the grid Form2 will use table1 and table 3 for...

Just a quick one tipsters. What is the maximum length that a sql varchar data type can hold for a string?? Can a VFP data field match the length of sql varchar data type when the varchar is already at its max?? or do i need to cut it into multiple parts before I can save it VFP data fields?

Does anybody know if there is a limitation to the number of receipients that you can send an email with vfp interfacing redemtion to outlook?? I asked this because I have encountered an OLE Dispatch error that kicks in whenever my receipients reaches more than 10. I was wondering if this is a...

Kevin, if you are going to use it for shared access in a network environment, I think it would be better if you use ODBC for VFP, and not just use the paths. This will also give you better protection for your database records. Just a thought.

Thanks for the info Darrell, but since I was merely using the formatting of the HTML option, I did manage to strip the parts that I think would encounter some problems for non-MS products, let's say I tried to make it simple without losing the Formats.

Hi Mikes, Done with this, I just finished a crash course just about 30 minutes ago, I had to retrace the HTML code generated by Word, and fortunately after some trial and error I was able to get my desired format. thanks for the directions.

Hi Mike, The reason I want it other than html option is, I find it very confusing to code using the html formats or approach, so I am looking for another way. And besides, I am not that too familiar with the html method of encoding. This would be a good way of learning the other properties...

Hi Techies, Here's another question that I hope would tickle your brains. I am already familiar with sending email using VFP. However, the messages that is in the email body is only pure text, wherein the format or presentation (like fonts) is inherited from the outlook setting. By using the...

Hi Mike, will you be kind enough as to direct me to Rick strahl's email class. thanks!

Thanks all, I was able to find the solution. I recall that in my previous installation I did complete all the necessary Service Packs for Visual Studio, and this was the missing part in my current setup. Everything is ok now after installing the Service Pack 5 for Visual Studio.

Hi Slighthaze, yup! exactly, if I look at it correctly the last character is chr(0). how do you do field mapping within a view?? How about those not in a view but contained in a create remote view command??

Hi Again Tipsters, I have this quite weird experience that I have encountered using VFP6 and SQL. First let me tell the history, I had VFP 6 installed previously in Windows 2000, where I used an ODBC connection to linked to SQL to fetch and insert data, works fine and I can read the data, no...

Dave, I think word will open the document based on the settings that document has, like if that document uses a pagelenght different from the printer it will open that document based on that pagelength. I tried exporting a report having the settings of dot matrix where I was able to change the...

hi Tia, how about trying this, I got this from some of the tips here, I just cant remember who actually gave this one to me, but I hope this works for you just like it did to me. #define SW_SHOW_HIDDEN 0 #define SW_SHOW_NORMAL 1 #define SW_SHOW_MINIMIZED 2 #define SW_SHOW_MAXIMIZED 3 oShell =...