Jump to content

George

Members
  • Content Count

    105
  • Joined

  • Last visited

Community Reputation

0 Neutral

About George

  • Rank
    member
  1. Have a look at this product www.alphasoftware.com Has runtime, frontend to MySQL, separate data files from rest of application, no plugin "pay-in" necessary for expected functionality, affordably priced, cross platform capable with Web Application Server...
  2. Just wanted to let you know that Alpha Software has released version 6 today with its own web application server and ability to interact LIVE (not import) with ADO / ODBC compliant databases, like Access, Oracle, SQL Server, and MySQL. www.alphasoftware.com or HERE for their slideshow!
  3. Given the facts of the above software license purchase requirements to distribute ones application to their respective clients, the math seems to show who is really giving the developer the potential for profit. Additional objectivity from this link:
  4. Kurt, you are right as to my membership here. I began using Filemaker at ver3 and helped to co-write a point of sale app in Alpha Four (DOS). I have an appreciation for both programs but, don't like the plug-in "patch work" that Filemaker has continued to force down it's userbase. You know as well as most users of this forum the numerous requests/rants about each FM ver release being lite on past developer tool wishes by users. I applaud the fact that you can SEE posts of Alpha's management personel contributing to Alpha's company maintained message board! Where is this userbase communication out of Filemaker? Being a user of both products, I am meerly posting my discoveries of strengths of a database product which I wanted to share with a forum of other developers. I have actually been excited in the past around the month of May hoping that Filemaker's next release will contain some of the simple features requested many times on this board. This forum and thread are providing all members a benefit. What's to harm in trying the free trial offer of Alpha? My best to all!
  5. True but... did you read their plans
  6. http://newsletter.alphasoftware.com/nw146.htm
  7. Since this is an invoicing system, it will always vary. As you can see from the image, if I query for Dept "ER" and WT >= .95 my report should include the 2 items in row 3 and 4.
  8. Thanks Ray, My specifics would be: In the Header I query for Salesman: Ray, Invoice date >= 1/1/2002 next I have added for query purposes, the 2 calc fields c_Dept and c_WT, which tunnel to 2 fields in Invtry, in the portal. Pseudo code is this: Since 1/1/2002, how many items of this weight, in this department has Ray sold.
  9. I have 3 files as follows: Header to Items; Items to Invtry. For tunneling I have created 2 calculated fields c_WT and c_Dept in Items. The 2 fields are in Invtry. My header form has a portal of Items fields plus these 2 calculated fields. When I perform a find on the Header form, one of my records that matches my find criteria may be on row 3 of the portal but the report only displays the item and amount of the incorrect record on row 1 of the portal, causing my report to be incorrect. How can I have the report use the correct record in the report? Thanks
  10. I did get the date argument to work with the following: ----------- "SELECT * FROM HEADER WHERE `HEADER`.`DATE` >= " & "#" &Year(lastupdate)& "-" & Month(lastupdate)& "-" & Day(lastupdate)& "#" ----------
  11. I could not get the SQL to work with the date value so I decided to use another field to choose my "new" records to import. What I have is a Calc field SQLquery("SELECT * FROM `HEADER` WHERE `HEADER`.`INV_NO` >=" & lastupdate) and a Global field (lastupdate,Text). I then created a script that first sorts by Inv_no then goes to the last record and sets field(lastupdate, "'"&Inv_no&"'") then executes the execute sql by using field value of SQLquery. The script runs and goes through the DSN prompts but does not add the records. To test my sql statement, I created a text field and created a script to set this fields value to the calc field SQLquery. I can then copy this value and begin to do a manual ODBC import and paste this value in and get a sucessfull SQL result and the correct records are added to FM. What could I check as to why the script can't pull in these records?
  12. Thanks Bob, sorry about the horizontal post. I eventually did think to use the asterick for my columns like in the following SQL statement <<< SELECT * FROM `HEADER` WHERE `HEADER`.`DATE` >= 2001-01-12 >>> problem now is the WHERE does not seem to make a successful find even though the data exists to satisfy the argument. Above is the statement that FM SQL Query builder is creating for the WHERE argument. I have tried the curly brackets around the date but no help. Last problem is, what should I use on the "import field mapping" screen? Add, Replace or "Update and add remaining"? I suspect add, provided the >= date argument is working properly in my query. My whole purpose in all of this is to hopefully speed up the import process by getting only the non existing records. Thanks
  13. FMP 5.5 I have this SQL import code: SELECT `HEADER`.`BAL_TOTAL`, `HEADER`.`CHARGE_AMT`, `HEADER`.`CREDITCARD`, `HEADER`.`CUST_ID`, `HEADER`.`DATE`, `HEADER`.`DUE_TOTAL`, `HEADER`.`EDIT`, `HEADER`.`EXP`, `HEADER`.`INV_NO`, `HEADER`.`LAST_NAME`, `HEADER`.`PAID_AMT`, `HEADER`.`PAID_OUT`, `HEADER`.`ROA`, `HEADER`.`SALES_TIME`, `HEADER`.`SALESMAN`, `HEADER`.`STATUS`, `HEADER`.`TAX_TOTAL`, `HEADER`.`TAXAB_TOT`, `HEADER`.`TAXRATE`, `HEADER`.`TERMS` FROM `HEADER` WHERE `HEADER`.`DATE` >= I would like to add a global field value of g_lastupdate after the >= in my code. I want to build a script step that sets the g_lastupdate value to the current date when ran; this lets the user know when the last update was performed and whether they feel they need to update the FM file. Also this greatly reduces the import time of 65000+ records. How can I pass this field value variable to the SQL argument? Thanks
  14. It appears to me that this should be a Relational type question. Why don't you have a directors db?
  15. Tired of the workarounds and lack of FMI releasing what they should have in each release? If you do not need cross platform use, you must try their demo. Offering encryption, Xbasic code for exceptional coding capabilities, print to pdf html from toolbar....Largest list of enhancements/improvements ever released. Free Trial www.alphasoftware.com
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.