Jump to content

Slamdunk

Members
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Slamdunk

  • Rank
    novice
  1. Hi, Using FM11 Pro, having some problems with ESS with MySQL v5.5. I know its not officially supported by FM. I can fire an ESS by writing a statement but if I make a stored procedure with same statement and then call it by ESS, it wont work. Any guesses or is it because of MYSQL v5.5?
  2. How to filter records in a portal with date range in FM 11 without relationship? I tried datefield >= $$date1 and datefield <= $$date2 but it displays records only equal to $$date1 (datefield = $$date1).
  3. Yes its done at driver lever if username and password is not stored in the external datasource. But if you store, it applies to all users which is dumb and lazy programming from Filemaker.
  4. Trying to get the user input in the password to pass it as calculation for external datasources (odbc) connection.
  5. Guys, Is there any function to get the user input in account password field while logon?
  6. Hi, I'd like to know if executing an SQL query is faster than using a filemaker calculated fields on a remote mysql database hosted on a webserver? Example: There two tables Clients & Invoices. Lets say I want to summarize total invoice amount per client. Which one of the two methods will calculate the result faster? 1. Execute SQL update statement sum(invoices.total) where client_code ="xyz" after every invoice created OR 2. Use filemaker calculated field in clients --> Total spent (Sum ( invoices::Total)) Has anyone
  7. Hi Guys, I managed to run the vbscript. It does changes the printer in the registry and changes the windows default printer, but it still doesnt change the printer in the FM. Any help? The VBscript is as follows: Set WshNetwork = CreateObject("WScript.Network") set WshShell = CreateObject("WScript.Shell") Serv = "DBS-EMAC" Printhere = "MFC-9160" AddSettings = ",winspool,DBS-EMACMFC -9160" FullPrinterName = ("" + Serv + "" + printhere) WshNetwork.SetDefaultPrinter FullPrinterName 'This sets the default printer for the computer NOT JUST FILEMAKER WshShell.RegWrit
  8. Hi Guys, I managed to run the vbscript. It does changes the printer in the registry and changes the windows default printer, but it still doesnt change the printer in the FM. Any help? The VBscript is as follows: Set WshNetwork = CreateObject("WScript.Network") set WshShell = CreateObject("WScript.Shell") Serv = "DBS-EMAC" Printhere = "MFC-9160" AddSettings = ",winspool,DBS-EMACMFC-9160" FullPrinterName = ("" + Serv + "" + printhere) WshNetwork.SetDefaultPrinter FullPrinterName 'This sets the default printer for the computer NOT JUST FILEMAKER WshShell.RegWrite
  9. Hi, I m still a novice with FM. Would appreciate if you could inform how to execute this vbscript from FM. (Step by step pls) Thanks,
  10. Hi Guys, Is there any way to change the printer name, paper size and paper source within FM and store it in windows registry? I'm using FM8.
×
×
  • Create New...

Important Information

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