Recent content by albertdc

Thanks for your patience, captain. I did exactly what you instructed, but, the icon for HTM/HTML is still different from the default; the extension names are still missing in the File Types tab. I don't think the IE shortcut on my desktop is screwed up. It opens w/o any hitch. Regards...

Thanks, captaincrunch00. I was able to do that. But, I can't seem to find the extension names HTM & HTML in the File Types tab on the Folder Options dialog box. And, the file's icon has also changed. Any idea how I can restore the extension name in File Types & restore the original icon for...

I'm using IE6sp1 on Win2k. Somehow, my html file association got messed up and now I can't open the files w/ IE by just double-clicking on them. I tried "Open With.." but that didn't retain the association. Albert Cobacha

how about giving this a try SELECT * ; FROM tblMembers WHERE YEAR(join_date) = 1956 ; AND YEAR(paid_tru) = 1957 ; AND YEAR(paid_tru) = 1958 ; ... so on ... AND YEAR(paid_tru) = 2006 tip: you may create the [ YEAR(paid_tru) = nnnn ] conditions dynamically by...

1. My VFP6 app runs on XP and can consume VFP data & SQL. But, on several instances, I encounter E_FAIL errors in ADO when the app tries to rs.addnew(). Any idea how to resolve this? 2. The same VFP6 app also encounters "check state" errors when adding records on some tables. I noticed that the...

He's skilled, no doubt. And the framework that he had us working w/ is quite good. It's just that it's probably not as evolved as other frameworks out there, considering that we've had the last framework update several years ago :( Albert Cobacha

btw, i tried rolling out, for now, the revisions w/c limits the list to 5 per group. i'm yet to hear feedback from production. :) thanks for all your time, guys!

Power corrupts, indeed. I'm not sure if what we have is a commercial framework. We have an offshore guy reviewing our code and if it's not "framework-compliant", it gets sent back to us for revisions. Overtime, we've kinda discovered the limits of the framework.

Hi Mike, We already have a similar framework in place. And we try to work w/in its limit as it's been part of many apps we have in production. Thanks for all your help! Albert

we're not allowed to use permanent tables either. :(

steve, unfortunately, our setup isn't like that. we're also forbidden to use remote views. our setup allows us to switch between backend w/o much trouble; we just switch a flag in a setup table and viola, we can choose to run our systems via ado-odbc-vfp or via ado-sql.

actually, i get the idea you guys are suggesting. it's just that in our setup, we can't use temporary table w/in the query because i need to submit the query through vfp-odbc via ado.

Thanks, Mike. But for some reason, we're not allowed to use SQLEXEC(). Any more ideas? thanks.

Thanks for your replies, guys. I'm using version 6.0. But, I don't think I can do w/ joining the cursors/tables. The list source comes from the cursor and the list is queried against a production table via ODBC/ADO. So, I need the actual list in the CmdText to pass to the backend. This is the...

I'm trying to determine the max length allowable for a sql query. The query form is SELECT * FROM table1 WHERE cfield1 IN (...) The above query is partly constructed by a UDF. The UDF supplies the WHERE clause from list of keys in a cursor. The list can grow, and when it does, I get the...