Recent content by northman

Hi Mark. Thank you. I was able to get it working. Here is what I did: ! Windows Date Determination DateSave# = Today() Date# = Date(1,15,2007) SetToDay(Date#) If Sub(Format(Today(),@D17),1,2) = 15 then !we have dd/mm/yyyy DateInd = 'D' Else DateInd = 'M' End...

How can I detect the setting for the Windows date (dd/mm/yyyy or mm/dd/yyyy) . I am using CW2 and running XP Pro. Thanks Serge

Hi Mark Thanks for your reply. I am using Version 4 for Windows, and I can not find the utilities you mentioned. Serge

If you define a field NewDate as long, here is a solution ! New Week NewDate = Date(Month(Today()),Day(Today())+7,Year(Today())) !End ! New Month NewDate = Date(Month(Today())+1,Day(Today()),Year(Today())) !End ! New Year NewDate = Date(Month(Today()),Day(Today()),Year(Today())+1) !End...

I need to know the file layout of an old version but unfortunately the source backups are not available. I get Error 47 trying to access the old database with the new version. It is not possible to convert it because the client is still using the old version and does not wish to migrate to the...

We may talk again! Serge

Hi Shankar: Works like a charm. Thanks so much. Tell me, where have you picked up all your knowledge for Clarion? I live too far from Toronto to meet with other programmers, so I am on my own. It is gratifying and so supportive to have people like you willing to answer questions. God...

Hi Shankar: Sorry for the delay...I have been sick with a cold. I tried: DosFileName STRING(12),STATIC DosFile FILE,DRIVER('DOS'),PRE(DOS),NAME(DosFileName) Record RECORD END END I assume that this is to be part...

Thanks Shankar: I may not have been clear about my problem, I can use Rename()/Copy() when I have defined that file in the dictionary. I am using Rename to create the back-up files (F2005.TPS, etc.). Where I am haveing trouble is Renaming/Copying a file that is not in the dictionary (such as...

Iwould like to archive my files at year end. For example I would rename FileA.TPS as F2005.TPA at the start of 2006, and rename FileA.TPS as F2006.TPA at the end of 2006, and so on. That part is easy. Now I would like to be able to bring back a file on special occasions (e.g. F2005.TPS ==>...

Hi: I am looking for a program to help develop Help files for Clarion. I used Helpburger but they seem to be out of business. Grateful for any suggestions. Thanks, Serge

Hi: I am using CW2 and would like to backup data to CDs instead of Floppies. I can't seem to find the way to do this. Would anyone have a solution to this? Thanks Serge

It's OK...I have found a way. A bit brute force, but it works!

Its OK, I have found a way. A bit brute force, but it works.

Is there a way to hide a column in a drop down browse box? I need the column for sort order, but don't want it displayed. I tried, unsuccesfully, to chang the FGnd and BGng colour at various points. CW2.0 Win XP Pro 2.4M Pentium 4, 512 MB memory Thanks. Serge