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 gkittelson 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: *

  1. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    Olaf, Mike Sorry I could not reply you for a long period. Stepping a few step back in this discussion I begin once again from where I had created two tables using- CREATE TABLE K:\P4\Saurabh\Tbl\TestDept ; (DeptID n(3) NOT Null, ; DeptName c(40) Not Null, ; HOD c(40) NOT Null, ; PRIMARY KEY...
  2. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    Yes Null arithmetic- not NULL = NULL NULL or false = NULL NULL or true = true NULL or NULL = NULL NULL and false = false NULL and true = NULL NULL and NULL = NULL So I will make the field Not Nullable. Moreover, I got yet another good lesson not to use DDL...
  3. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    Finally my modified structures are: 1. Create Table Dept ; (DeptID n(3) Not Null Unique, ; DeptName c(40) Not Null, ; HOD c(40) Not Null, ; Primary Key DeptID Tag DeptID) and 2. Create Table emp ; (Eid n(3) Not Null Unique, ; EName c(40) Not Null, ; Gender c(1) Null Check Gender = 'M' Or...
  4. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    Copy and Paste can paste can be done from RDP but due to security reasons it is restricted from the server side.
  5. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    Truly said....
  6. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    Thank you Olaf. With Currency datatype and Tag DeptID my table was successfully created. Working through RDP, that's why couldn't copy and paste the code, Sorry it troubled you. I was using logical L(1) data type but that was absurd with "Null Check Gender = 'M' Or Gender = 'F'", It was not...
  7. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    That worked. Adding TAG did solve the error in the 2nd line.
  8. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    Thank you for the quick reply. Actually that is my mistake in copying and pasting the code. Please ignore that. I tried checking the code including lines one by one. The error comes when I include any of the following two lines of codes- - Salary n(6) Null Default 0, and - DeptID n(3)...
  9. SSAAHW

    Create Table involving Primary Key, Null, Not Null and References

    I have written following create table structures- 1. Create Table Dept ; (DeptID n(3) Primary Key, ; DeptName c(40) Not Null, ; HOD c(40) Not Null) and 2. Create Table emp ; (Eid n(3) Primary Key EName C(40) Not Null, ; Gender l(1) Null Check Gender = 'M' Or Gender = 'F', ; Salary n(6) Null...
  10. SSAAHW

    "OLE error code 0x800700CA: unknown com status code" on windows server 2012 r2, when runni

    Users complain that "Once this error is corrected (by restart or by OLEDB) the problem starts as soon as the new exe is given to them
  11. SSAAHW

    "OLE error code 0x800700CA: unknown com status code" on windows server 2012 r2, when runni

    On Windows server 2012 R2, we have our software based (on vfp9). When users click the .exe of the software or switches the branch they get following error which is similar to the above mentioned error. "OLE error code 0x800700CA: unknown com status code" This error never came on windows...
  12. SSAAHW

    How to transfer vfp environment from one system to another ?

    Mine was just like hit and trial but yours is a detailed soln. Thanks.
  13. SSAAHW

    How to transfer vfp environment from one system to another ?

    Found the soln. Intellisense env. - appending from foxcode.dbf and Macros - from fky Actually vfp was installed both on source and destinatination server. Just environment needed to be synchronized. Sorry I was late but got tremendous pleasure and satisfaction to see the same soln. from...
  14. SSAAHW

    How to transfer vfp environment from one system to another ?

    Today this process of transferring the registry keys were really performed. It was successfully copied from the source windows server 2008 to the destination server (windows server 2012), run and the window that popped up also shown that the process has successfully completed. But when tested...
  15. SSAAHW

    How to transfer vfp environment from one system to another ?

    @OlafDoschke "... Seems you already worked with VFP on your old computer quite a while." To be a bit more clear, till now I have not started working with macros and have merely an introduction of its working. But I had an assignment from my senior to find about importing macros also besides...
  16. SSAAHW

    How to transfer vfp environment from one system to another ?

    Thanks again to both of you.
  17. SSAAHW

    How to transfer vfp environment from one system to another ?

    Thank you very much to both MikeLewis and OlafDoschke. I have just begun programming and that too with vfp, am an O level programmer. Your answers especially last three appealed to me quite well and solved my issue. Thanks a lot again.
  18. SSAAHW

    How to transfer vfp environment from one system to another ?

    This should include macros setting and other environment settings. Is this import of setting possible with using config.fpw file?

Part and Inventory Search

Back
Top