Ingar
-
Posts
12 -
Joined
-
Last visited
Ingar's Achievements
-
Hi, I need a bit of advice on what to do. What I need: I have a CRM software with all my customers. ( And I can't swap this with FMPro ). This is SQL based. I have an order DB and a customer DB in FMPro which I need to link to my CRM system. The Customer DB has to be up to date against the SQL DB. Then I would like to perform a search in FMPro to look up a customer. If the customer doesn't exist I have to use Visual Basic code to add a customer to my CRM system. The reason why I have to use Visual Basic is that my CRM uses the COM/DCOM technology from MS and I have to program against this. ( Because of rules and default values that is defined in the components ). Is it possible to run Visual Basic code from inside FMPro and how should i make FMPro and SQL DB to be synchronized ? I hope someone understands my needs, english is not my main language. Ingar
-
Hi! Thanks a lot for your answers Anatoli and Garry, you both has helped me a lot. Sometimes I think it's like I'm going blind if I stare at the same problem to long. The removal of the [FMP-field: ] was one of things I had to do. The testing with the Find in FMP also helped me as I could see that the fields was filled out with the right words, but the search for "less than" in the date field was wrong. I use FrontPage to do the design at the Web site and I just edit the CDML code directly here. I had been testing the solution with the date find earlier and thought that I'd just added an extra search for the related field. But in this edit action I had open the properties for my Select "-op" and when I closed this, Frontpage renamed this to Select "D1". So the Find stopped in the date field and not in the Users:department as I believed. Again, thanks a lot Ingar
-
Hi! Have the following sollution in FMP: calendar.fp5: Fields: date, name, time, NameID users.fp5: Fields: NameID, name, department NameID related to NameID, relationship is named Users. In calendar.fp5 I have a layout (list) with: date, time, name, nameID, users::department In Web companion i have an index.htm redirecting to: <a href="http://localhost/FMPro?-db=calendar.fp5&-lay=list&-format=search.htm&-findall"> In the search.htm i use this code: <HTML> <HEAD> <TITLE>Search</TITLE> </HEAD> <BODY> <H2>Title</H2> <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-Op" VALUE="eq" <INPUT TYPE="hidden" NAME="-error" VALUE="error.htm"> <INPUT TYPE="hidden" NAME="-format" VALUE="result.htm"> <INPUT TYPE="hidden" NAME="-lay" VALUE="form"> <INPUT TYPE="hidden" NAME="-db" VALUE="Calendar.fp5"> <P>Department: <SELECT NAME="-op" value="equals"> <OPTION SELECTED value="equals"> <OPTION value="not equals"> <OPTION value="contains"> <OPTION value="begins with"> <OPTION value="ends with"> </SELECT> <INPUT TYPE="text" NAME="[FMP-field: users::department]" VALUE=""> <P>To Date: <P> <SELECT NAME="-op" value="less than"> <OPTION value="equals"> <OPTION value="not equals"> <OPTION SELECTED value="less than"> <OPTION value="contains"> <OPTION value="begins with"> <OPTION value="ends with"> </SELECT> <P><INPUT TYPE="text" NAME="date" VALUE="[FMP-Currentdate]"> <P><!-- STEP 7. SPECIFY THE BUTTON ACTION--> <p><INPUT TYPE="submit" NAME="-find" VALUE="Search"></p> <p><INPUT TYPE="reset" VALUE="Reset"></p> </FORM> </BODY> </HTML> What I'm trying to do is to perform a find action with a department and a date to see all appointments for this department before a certain date. But if I put in the values "sales" and "08.08.2003" in the text boxes I only get the result: No records found. If I do the same find in the list- layout in FMP the records containg "sales" in the department field shows up just fine. It may be an easy answer to this, I'm pretty new to the CDML programming. ( I've tried to look trought the Fmforum, but haven't found an answer to this problem). Hope someone can help, as it seems to be quite a few FMP experts out there. Ingar
-
Yes it was open. It makes no sense to me. Ingar
-
Hi! My problem was that I used this input in a search page: <P><INPUT TYPE="text" NAME="_Cday" VALUE="[FMP-Currentdate]" In the Web page it showed up as [FMP-Currentdate] My link to the page is this: <a href="http://localhost/FMPro?-db=mybase.fp5&-lay=layout&-format=search.htm&-view"></a></p> When I moved the DB to the Web folder it showed up just fine in the Web page. But to my surprise, when I move the DB back to the original folder it also shows up fine. Now I really don't know what happend. It works fine at this moment but I'm not shure if stays this way later. Ingar
-
Web security combined with FmPro Access
Ingar replied to Ingar's topic in Other Internet Technologies
Hi! I would like to inform yoy all that the first question in this thread was written when I was using FMPro 5.0 but after I upgraded to v6.0 the problem disappeared. In this version when I try to do a Exact search and one criteria fails I just get a box saying: Access Restictio ; You do not have access.... And was just the way I wanted it to do Ingar -
Hi! I've seen a lot of questions about the use of URL's to access FMPro DB, but I wonder about something. If I have a DB at the following location: C:program filesdbmybase.fp5 and my web pages is in the FilemakerWeb folder how will the URL look: http://localhost/FMPro?-db=:?&-lay=layout&-format=search.htm&-view Ingar
-
Hi! I have a search page with this code: <P><INPUT TYPE="text" NAME="_cday" VALUE="01/01/2003" <P><INPUT TYPE="text" NAME="_cday" VALUE="31/12/2003" This code works fine, but I would like to have the date in the second line to show the date today. I have tried to do this: <P><INPUT TYPE="text" NAME="_Cday" VALUE="[FMP-Currentdate]" But this only show up as [FMP-Currentdate] in the text box. The DB is located in another folder than the Web-folder. In the browser I open the URL: http://localhost/search.htm Maybe there is another way to get the wanted result. I hope someone can give me a clue on what to do. Ingar
-
Web security combined with FmPro Access
Ingar replied to Ingar's topic in Other Internet Technologies
Maybe I have expressed my self wrong (English is not my main language). First off all I thought I could use both Access rights as there is an option filling in a DB password in the Web security. But even without this there still is a problem if I delete all the Groups and Passwords in the FM DB and use only the Web security DB. I have 2 fields in the WS Db with the Exact search option. If one or both of them is missing (or wrong) when I try to perform a search then the Connect to "host" dialog box still pop up instead of my Error page. Since I don't have any user name or password in the DB, the only way to get out of this is to use the Cancel button. I hope this make more sense to you. Ingar -
Web security combined with FmPro Access
Ingar replied to Ingar's topic in Other Internet Technologies
The FM Client is open with a password. This password has everything enabled. If I don't use the Exact search option I can fill in this password on the Web page and the search completes with my results page. But with the Exact match option and one missing criteria it all stops with this dialog box. The user can't get further no matter what he types in this fields. The best way to quit this is to use the Cancel button, the page then returns to the search page. Ingar -
Hello! I'm trying to build a web page with access to a Filemaker database. I use the Web security database with a Field restriction and Exact search option. I have used All users and no password. The Web security record is provided with the admin password of the DB. When I do a search on the Web site and the Exact search criteria is not true then I want to have an error page as an result ( This works fine if I don't use the Exact search option). Instead I get a Connect to "host" box in the browser asking for User name and Password. Then I have to use Cancel to return to the search page. I think the trouble is that I use a combination of Web security and FmPro Access. When the Exact search criteria is false then Filemaker tries to use Fmpro Access rights and thereby the dialog box pops up. Is there any way to omit this dialog box or if I could make this box default to Cancel and perform this without any action from the user I would be very happy. If the box also could be /invisble, so much better! Hope someone have some thoughts about this. -) Ingar mailto:ingar@minpost.as
-
Hello! I'm trying to open an SQL database with Filemaker Pro 5.0V1. The SQL statement says: SELECT Customer.CustomerNo, Customer.Name FROM Customer I get an error saying Object name Customer is invalid. To correct this I must add the table owner as shown below. SELECT MDBS.Customer.CustomerNo, MDBS.Customer.Name FROM MDBS.Customer MDBS beeing the user / owner of the SQL table. Is there any way to omit this editing in every query? Either in the DSN or in the SQL database.