Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: albertdc
  • Order by date
  1. albertdc

    HTM/HTML files do not open w/ IE

    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...
  2. albertdc

    HTM/HTML files do not open w/ IE

    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...
  3. albertdc

    HTM/HTML files do not open w/ IE

    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
  4. albertdc

    Select where date is incremented

    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...
  5. albertdc

    E_FAIL & Null errors in VFP6 via ADO/ODBC

    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...
  6. albertdc

    statement too long

    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
  7. albertdc

    statement too long

    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!
  8. albertdc

    statement too long

    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.
  9. albertdc

    statement too long

    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
  10. albertdc

    statement too long

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

    statement too long

    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.
  12. albertdc

    statement too long

    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.
  13. albertdc

    statement too long

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

    statement too long

    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...
  15. albertdc

    statement too long

    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...
  16. albertdc

    Insert Comment with Date

    Thanks for your reply, Mike. I did a little tinkering and came up with this: DEFINE BAR 5018 OF _MTOOLS ; PROMPT "\<Developer's Comment" ; AFTER _MTL_OPTNS ; KEY ALT+D ON SELECTION BAR 5018 OF _MTOOLS ; DO InsertProgsComment IN HOME() + "vfpstart.prg"...
  17. albertdc

    Insert Comment with Date

    Currently, I have a SHIFT+CTRL+D macro assigned for this in default.fky with the ff. "&&{SPACEBAR}MyName{SPACEBAR}<<DATE>>". However, I'd like to expand "<<DATE>>" to the actual date. How can this be done in VFP6? Thanks!
  18. albertdc

    Error C0000005 on CALCULATE CNT() of a large table

    the NOUPDATE keyword seems to be the answer. i reverted to using CALCULATE CNT() TO ARRAY lnCount without further errors.
  19. albertdc

    Error C0000005 on CALCULATE CNT() of a large table

    thanks for ur suggestions! i'll try them both and let u know the results.
  20. albertdc

    Error C0000005 on CALCULATE CNT() of a large table

    table is 500mb the code below is in a procedure that repeatedly called for each table in the folder. SELECT (lcAlias) ?'Counting records...' CALCULATE CNT() TO lnCount IF _TALLY = 0 lnCount = 0 ENDIF USE IN (lcAlias) using vfp6 sp5 under Win2k Pro we already tried the ff. statements but...

Part and Inventory Search

Back
Top