Instead of a view - Is this possible or nonsense

Author	Message
Thomas Holste	Thomas Holste posted 10 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 144, Visits: 618	Hi there, I wonder if something like this would work. I got a BO which maps one table and send a SQL-command like this select table1.field1, table1.field2*table1 as somecalcfield, table2.anotherfield from table one left outer join table2 on....... I know, that I could easily get this by using a view and map it but for reasons of runtime-flexibility I would like to know if this field from table2 can be accessed through the BO which maps only table1. It would make some situations easy where I want to replace foxpro-code utilizing the create cursor-command. Thanks in Advance Thomas
	Reply Like 1

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Thomas Holste - 10 Years Ago

Thomas: You can most definitely access it and you can even create a...

Trent L. Taylor - 10 Years Ago

Hi Trent, thank you for your answer but how do I implenet...

Thomas Holste - 10 Years Ago

You would just copy one of the fields from the designer file on the...

StrataFrame Team - 10 Years Ago

Hi Ben, thanks a lot for your help. Your example has taught me a fine...

Thomas Holste - 10 Years Ago

Nothing to be insecure about, Thomas :) The BOs are used to save...

StrataFrame Team - 10 Years Ago

Hi Ben, thanks again for your help, Best regards Thomas

Thomas Holste - 10 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login