Re: [twsocket] Midware create serverobject 'problem'.
Hi All, I am currently trying to understand the transport of variables in the midware functions. I create a serverobject like in 'my first server'. This idea works just fine. Now I went a step further, and probably I am looking in the wrong spot.. I created a function for looking up a variable in a database in my server-application, so the query is not in the server-object but in the main-form application (see small snippet below). Now I want to call that query-function from the serverobject I created, however I am not able to call that function.. The function I created is public, or private, but seems not to get availlable in the serverobject. Do I need to do something special to transfer this function or data to the main-screen and get the result back? I have been looking in the demo, but in some way I get lost in the way it transfers this data.. This is the function declared in the main-unit/form : function getsat ( sat : string):string; var sat : string; begin with service2.satqry do begin sql.Clear; sql.Text := 'Select * from `satellite` where `option` = ''' + sat + ; sql.open; end; end; Any idea what I need to do? Best regards, Ruud Kerstens -Oorspronkelijk bericht- From: Ruud Kerstens Sent: Sunday, January 23, 2011 6:36 PM To: ICS support mailing Subject: Re: [twsocket] Midware create serverobject 'problem'. Hi Francois, Well, you caught me there, as I was thinking the Tier-2 way as well. Now after reading your email I fully understand the idea behind the Midware. This will make life much easier for me as you can create as many different clients as you like, all just ask for items they need. The good thing is indeed that I don't care what the 'server' does, as long as it gets what it needs. What is perfect as well, is that in that case only server needs to be changed when things need to alter, and the client does not really need updating (unless new items to be displayed etc). Thank you for the reply, and explanation, Best regards, Ruud -Oorspronkelijk bericht- From: Francois PIETTE Sent: Sunday, January 23, 2011 8:59 AM To: ICS support mailing Subject: Re: [twsocket] Midware create serverobject 'problem'. Got the first server working now, so that is fine. :-) Despite of the demo's i see for ADO and BDE, i am using another database (absolutedatabase : www.componentace.com), which is a BDE replacement. Is this just as easy to connect as the examples that are included with Midware, or do i need to create my own 'BDE' serverobject? Yes, it is just as easy with any database component. Midware at server side is simply not concerned by the component you use. Use whatever you like ! And client side is completely independent of what you use at server side. Please not that many developer are falling in a frequent design error when dealing with multitier: they are transporting SQL request from client to server. This works of course but this is really not the design for 3-tier programming. Transporting SQL request is simple 2-tier (classical client/server). To really befenit from 3-Tier architecture, you have to think at a higher level. The client do not know anything about database, storage and similar topics. It only knows about high level concepts of curse much of these high level concept can be expressed as SQL request, but don't do it at client side ! All SQL must go to server side. The client must not know the database, the tables, fields and indexes ! It only knows things such as GetClient and how to pass parameters which refines the search, it knows about SaveDocument and send the document. The server know where and how the documents are stored and what has to be verifyed to accept a document. Best regards, -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be
Re: [twsocket] Midware create serverobject 'problem'.
You should use UserData. This is the recommanded way of passing data to the serverobject. Usually this userdata is an instance of a datamodule but can be anything. There are demos with it. Simply search for userData. -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be - Original Message - From: Ruud Kerstens ruud.kerst...@hotmail.com To: ICS support mailing twsocket@elists.org Sent: Monday, January 24, 2011 8:13 PM Subject: Re: [twsocket] Midware create serverobject 'problem'. Hi All, I am currently trying to understand the transport of variables in the midware functions. I create a serverobject like in 'my first server'. This idea works just fine. Now I went a step further, and probably I am looking in the wrong spot.. I created a function for looking up a variable in a database in my server-application, so the query is not in the server-object but in the main-form application (see small snippet below). Now I want to call that query-function from the serverobject I created, however I am not able to call that function.. The function I created is public, or private, but seems not to get availlable in the serverobject. Do I need to do something special to transfer this function or data to the main-screen and get the result back? I have been looking in the demo, but in some way I get lost in the way it transfers this data.. This is the function declared in the main-unit/form : function getsat ( sat : string):string; var sat : string; begin with service2.satqry do begin sql.Clear; sql.Text := 'Select * from `satellite` where `option` = ''' + sat + ; sql.open; end; end; Any idea what I need to do? Best regards, Ruud Kerstens -Oorspronkelijk bericht- From: Ruud Kerstens Sent: Sunday, January 23, 2011 6:36 PM To: ICS support mailing Subject: Re: [twsocket] Midware create serverobject 'problem'. Hi Francois, Well, you caught me there, as I was thinking the Tier-2 way as well. Now after reading your email I fully understand the idea behind the Midware. This will make life much easier for me as you can create as many different clients as you like, all just ask for items they need. The good thing is indeed that I don't care what the 'server' does, as long as it gets what it needs. What is perfect as well, is that in that case only server needs to be changed when things need to alter, and the client does not really need updating (unless new items to be displayed etc). Thank you for the reply, and explanation, Best regards, Ruud -Oorspronkelijk bericht- From: Francois PIETTE Sent: Sunday, January 23, 2011 8:59 AM To: ICS support mailing Subject: Re: [twsocket] Midware create serverobject 'problem'. Got the first server working now, so that is fine. :-) Despite of the demo's i see for ADO and BDE, i am using another database (absolutedatabase : www.componentace.com), which is a BDE replacement. Is this just as easy to connect as the examples that are included with Midware, or do i need to create my own 'BDE' serverobject? Yes, it is just as easy with any database component. Midware at server side is simply not concerned by the component you use. Use whatever you like ! And client side is completely independent of what you use at server side. Please not that many developer are falling in a frequent design error when dealing with multitier: they are transporting SQL request from client to server. This works of course but this is really not the design for 3-tier programming. Transporting SQL request is simple 2-tier (classical client/server). To really befenit from 3-Tier architecture, you have to think at a higher level. The client do not know anything about database, storage and similar topics. It only knows about high level concepts of curse much of these high level concept can be expressed as SQL request, but don't do it at client side ! All SQL must go to server side. The client must not know the database, the tables, fields and indexes ! It only knows things such as GetClient and how to pass parameters which refines the search, it knows about SaveDocument and send the document. The server know where and how the documents are stored and what has to be verifyed to accept a document. Best regards, -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list
Re: [twsocket] Midware create serverobject 'problem'.
Got the first server working now, so that is fine. :-) Despite of the demo's i see for ADO and BDE, i am using another database (absolutedatabase : www.componentace.com), which is a BDE replacement. Is this just as easy to connect as the examples that are included with Midware, or do i need to create my own 'BDE' serverobject? Yes, it is just as easy with any database component. Midware at server side is simply not concerned by the component you use. Use whatever you like ! And client side is completely independent of what you use at server side. Please not that many developer are falling in a frequent design error when dealing with multitier: they are transporting SQL request from client to server. This works of course but this is really not the design for 3-tier programming. Transporting SQL request is simple 2-tier (classical client/server). To really befenit from 3-Tier architecture, you have to think at a higher level. The client do not know anything about database, storage and similar topics. It only knows about high level concepts of curse much of these high level concept can be expressed as SQL request, but don't do it at client side ! All SQL must go to server side. The client must not know the database, the tables, fields and indexes ! It only knows things such as GetClient and how to pass parameters which refines the search, it knows about SaveDocument and send the document. The server know where and how the documents are stored and what has to be verifyed to accept a document. Best regards, -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be
Re: [twsocket] Midware create serverobject 'problem'.
Hi Francois, Well, you caught me there, as I was thinking the Tier-2 way as well. Now after reading your email I fully understand the idea behind the Midware. This will make life much easier for me as you can create as many different clients as you like, all just ask for items they need. The good thing is indeed that I don't care what the 'server' does, as long as it gets what it needs. What is perfect as well, is that in that case only server needs to be changed when things need to alter, and the client does not really need updating (unless new items to be displayed etc). Thank you for the reply, and explanation, Best regards, Ruud -Oorspronkelijk bericht- From: Francois PIETTE Sent: Sunday, January 23, 2011 8:59 AM To: ICS support mailing Subject: Re: [twsocket] Midware create serverobject 'problem'. Got the first server working now, so that is fine. :-) Despite of the demo's i see for ADO and BDE, i am using another database (absolutedatabase : www.componentace.com), which is a BDE replacement. Is this just as easy to connect as the examples that are included with Midware, or do i need to create my own 'BDE' serverobject? Yes, it is just as easy with any database component. Midware at server side is simply not concerned by the component you use. Use whatever you like ! And client side is completely independent of what you use at server side. Please not that many developer are falling in a frequent design error when dealing with multitier: they are transporting SQL request from client to server. This works of course but this is really not the design for 3-tier programming. Transporting SQL request is simple 2-tier (classical client/server). To really befenit from 3-Tier architecture, you have to think at a higher level. The client do not know anything about database, storage and similar topics. It only knows about high level concepts of curse much of these high level concept can be expressed as SQL request, but don't do it at client side ! All SQL must go to server side. The client must not know the database, the tables, fields and indexes ! It only knows things such as GetClient and how to pass parameters which refines the search, it knows about SaveDocument and send the document. The server know where and how the documents are stored and what has to be verifyed to accept a document. Best regards, -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be
Re: [twsocket] Midware create serverobject 'problem'.
Hi ! Search where v.pas file is on your system and add that folder to Delphi search path. It is likely that this file is in midware folder. -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be - Original Message - From: Ruud Kerstens ruud.kerst...@hotmail.com To: ICS support mailing twsocket@elists.org Sent: Saturday, January 22, 2011 7:36 PM Subject: [twsocket] Midware create serverobject 'problem'. Hi All, I am using the latest ICS and Midware in Delphi XE, which works fine sofar. I can run the demo’s and I really like the Midware options, however when I follow the tutorial ‘My First server’ I get into trouble.. First steps work fine, until step 6, which I skip as it is optional as mentioned in that part. (No image editor in XE as well). Step 7 is what gets me in trouble. I follow the actions as mentioned, and when I click compile/Install, it is asking for the dcu-files ([DCC Fatal Error] OverbyteMwDXeRun.dpk(61): F1026 File not found: 'OverbyteSObjBdeSql.dcu') The Midware-library is in the path (demo’s work fine as well), and I checked the search-path in the screen as well, which also uses the midware library-path. Anybody an idea what I might be doing wrong? Best regards, and thanks, Ruud Kerstens -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be
Re: [twsocket] Midware create serverobject 'problem'.
PS, i do not find any v.pas, is this really needed? Actually I wanted to type CTRL+V to insert 'OverbyteSObjBdeSql' I copied but ctrl key was lost :-( -- francois.pie...@overbyte.be http://www.overbyte.be - Original Message - From: Ruud Kerstens ruud.kerst...@hotmail.com To: twsocket@elists.org Sent: Saturday, January 22, 2011 9:08 PM Subject: Re: [twsocket] Midware create serverobject 'problem'. Hi Francois, Thanks for responding! Well, there was my mistake, I only added the VC32 directory to my library-directory's, and not the midware-directory, as I thought it was only demo's.After adding to the library-directory's it is working. Anyway, thank you Francois for the help, and have a good weekend. Best regards, Ruud Kerstens PS, i do not find any v.pas, is this really needed? From: francois.pie...@skynet.be To: twsocket@elists.org Date: Sat, 22 Jan 2011 20:51:04 +0100 Subject: Re: [twsocket] Midware create serverobject 'problem'. Hi ! Search where v.pas file is on your system and add that folder to Delphi search path. It is likely that this file is in midware folder. -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be - Original Message - From: Ruud Kerstens ruud.kerst...@hotmail.com To: ICS support mailing twsocket@elists.org Sent: Saturday, January 22, 2011 7:36 PM Subject: [twsocket] Midware create serverobject 'problem'. Hi All, I am using the latest ICS and Midware in Delphi XE, which works fine sofar. I can run the demo’s and I really like the Midware options, however when I follow the tutorial ‘My First server’ I get into trouble.. First steps work fine, until step 6, which I skip as it is optional as mentioned in that part. (No image editor in XE as well). Step 7 is what gets me in trouble. I follow the actions as mentioned, and when I click compile/Install, it is asking for the dcu-files ([DCC Fatal Error] OverbyteMwDXeRun.dpk(61): F1026 File not found: 'OverbyteSObjBdeSql.dcu') The Midware-library is in the path (demo’s work fine as well), and I checked the search-path in the screen as well, which also uses the midware library-path. Anybody an idea what I might be doing wrong? Best regards, and thanks, Ruud Kerstens -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be
Re: [twsocket] Midware create serverobject 'problem'.
Hi Francois, Got the first server working now, so that is fine. Just discovered that when i change the objserver file, i need to recompile this component to get it working, but it works just fine. Despite of the demo's i see for ADO and BDE, i am using another database (absolutedatabase : www.componentace.com), which is a BDE replacement.Is this just as easy to connect as the examples that are included with Midware, or do i need to create my own 'BDE' serverobject? Best regards, Ruud From: francois.pie...@skynet.be To: twsocket@elists.org Date: Sat, 22 Jan 2011 21:28:49 +0100 Subject: Re: [twsocket] Midware create serverobject 'problem'. PS, i do not find any v.pas, is this really needed? Actually I wanted to type CTRL+V to insert 'OverbyteSObjBdeSql' I copied but ctrl key was lost :-( -- francois.pie...@overbyte.be http://www.overbyte.be - Original Message - From: Ruud Kerstens ruud.kerst...@hotmail.com To: twsocket@elists.org Sent: Saturday, January 22, 2011 9:08 PM Subject: Re: [twsocket] Midware create serverobject 'problem'. Hi Francois, Thanks for responding! Well, there was my mistake, I only added the VC32 directory to my library-directory's, and not the midware-directory, as I thought it was only demo's.After adding to the library-directory's it is working. Anyway, thank you Francois for the help, and have a good weekend. Best regards, Ruud Kerstens PS, i do not find any v.pas, is this really needed? From: francois.pie...@skynet.be To: twsocket@elists.org Date: Sat, 22 Jan 2011 20:51:04 +0100 Subject: Re: [twsocket] Midware create serverobject 'problem'. Hi ! Search where v.pas file is on your system and add that folder to Delphi search path. It is likely that this file is in midware folder. -- francois.pie...@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be - Original Message - From: Ruud Kerstens ruud.kerst...@hotmail.com To: ICS support mailing twsocket@elists.org Sent: Saturday, January 22, 2011 7:36 PM Subject: [twsocket] Midware create serverobject 'problem'. Hi All, I am using the latest ICS and Midware in Delphi XE, which works fine sofar. I can run the demo’s and I really like the Midware options, however when I follow the tutorial ‘My First server’ I get into trouble.. First steps work fine, until step 6, which I skip as it is optional as mentioned in that part. (No image editor in XE as well). Step 7 is what gets me in trouble. I follow the actions as mentioned, and when I click compile/Install, it is asking for the dcu-files ([DCC Fatal Error] OverbyteMwDXeRun.dpk(61): F1026 File not found: 'OverbyteSObjBdeSql.dcu') The Midware-library is in the path (demo’s work fine as well), and I checked the search-path in the screen as well, which also uses the midware library-path. Anybody an idea what I might be doing wrong? Best regards, and thanks, Ruud Kerstens -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be