Search results for query: *

It sounds like your data isn't adhering to good Normalization standards. That alone introduces additional challenges in gathering the data into a useful manner for Reports, etc. You might want to consider re-designing your data architecture to a more Normalized manner. Good Luck, JRB-Bldr

I might add that if you are unfamiliar with how to build a VFP EXE, you might want to spend some time looking at the free, on-line, tutorial videos at: GarfieldHudson Free Tutorials Most especially those titles: Building a Simple Application Good Luck JRB-Bldr

You can look into your VFP Help file for how to use SYS(11) It will give you the Julian Date for the desired date. Then, if you need SECONDS, you can convert the Julian Date. Good Luck JRB-Bldr

A word of caution. Do Not store the JPG image itself in any data table field. Instead store the JPG file itself in a Windows directory and store its fully pathed file name in the data table. That way your application can readily 'find' and use it. It is a much safer approach. Good Luck...

I assume that you are using the VFP Menu's SKIP FOR ... methods and/or the LOAD/INIT methods for individual VFP Forms as your Role Based access control. If so, then its not very difficult to add one or more additional conditions from a Custom Role to the qualifying (or Not-Qualifying) criteria...

This is not the same question as: FIRST - Questions about new/different issues are to be posted into a new Posting Thread, not re-use an existing thread. SECOND - Fields are not updated in any 'AUTOMATIC' manner. It takes code to make it occur. And depending on how/where the value from the...

Some good points have been raised above. 1) You cannot LEGALLY decompile code that you do not LEGALLY OWN. Not just own Run-Time Rights, but own Source-code Rights. 2) Your initial thread subject indicates "ANY" foxpro application. That causes us to question how you intend to use the...

I just now did a search for one of the less common Page Sizes which I found in my Print Setup - Page Size. I found it listed in the system's Registry as a DsDriver - printMediaReady and DsDriver - printMediaSupported entries for each of the printers that I can use. I am not sure what would...

While I haven't used it for a good while now, for 'generic' FTP operations I was using the routines found at: How do I transfer files using FTP? Those routines use the Default FTP Port 21, but the parameter passed is '0' indicating USE THE DEFAULT PORT. Good Luck, JRB-Bldr

You might want to look at: Test remote SQL connectivity EASILY You can separately check your ability to connect to each of the separate Access databases. Once you have got BOTH of them working, you can then open the UDL files with notepad and you will see the connection string to that SQL you...

At least as far as SQL JOIN's go I often recommend that a new developer look over: Inner-Outer JOINs Good Luck, JRB-Bldr

OK. So your remote server is providing you a Web Service using one of the HTTP protocols and not an FTP/SFTP site. Now you need to find out if that Web Service is supporting HTTP PUT's or HTTP POST's because your code will need to differ somewhat depending on which it is. And you will need...

I agree with what Olaf has said. NO you do not have to use an HTTP <Anything> to merely transfer a file from your site to another site. In some cases you use an HTTP PUT/POST and in others you use FTP/SFTP - it all depends on what the receiving site is providing for your use. It sounds like...

pcwaleed - While RANDOM assignment is a very poor way to assign ID's - if all you want to do is to assign ID's to the Names in the other table you can do with a small VFP program which looks something like what follows: * --- The following assumes that there are as many or more ID's than...

kuma - Welcome to the forum. You have provided a very general description of what you intend to create And, based on what you describe, it can be 'architected', designed and developed in a variety of ways. That is basically up to you to decide how to do it. I'd suggest that after deciding on...

Is your Grid displaying ONLY the records of your original 'primary' table? Or is the Grid displaying the records from a SQL Query where the 'primary' table is combined in some manner with one or more other 'secondary' tables? If the later, look in your 'secondary' tables for duplicate records...

It is NOT required for the Parent and the Child to have the SAME Index active. Yes the Child table must have an Active Index (SET ORDER TO <whatever>) But the Parent does NOT need to have ANY Index active or it may have a totally different Index Active. USE ChildDBF IN 0 ORDER Index1 USE...

Since it appears as though you have already set up an ODBC Data Source Connection in your Windows, you might want to look at: How to Connect to a SQL Server from Visual FoxPro Good Luck, JRB-Bldr

Olaf - You did it AGAIN !!!!! NOTE: That is not, in any way, to be-little Mike's and Griff's numerous examples of great advice/suggestions over the years. I had done a completely new installation of VFP9 onto this new workstation. But I had not done the VFP9.EXE /regserver or FoxHHelp9.EXE...

Oh well, we have probably wasted too much brain-power on this already. I had hoped that there would be a simple resolution, but apparently NO. I want to thank everyone who offered advice. Your suggestions/advice was greatly appreciated. Thanks, JRB-Bldr