Apollo set relation help

For programmers who have experience with [login to view URL] database driver. We use Version 9 right now. If you do not know apollodb do not quote.

You must have apollo and all dlls needed. we are not providing anything. we are looking for someone to just help us solve the problem below. Only paying for a working code that works with apollodb asp.net database controls.

Our request is simple. Create ASP.net application that takes two dbf and joins them via set relation command in apollodb and allows us to query the two databases using indexes. We will test with two databases of 100k in size to make sure indexes are geing used.

This is not a actual project I just need to see how to do this code properly because it is not working for us and need a solution. Apollo support is non responsive and we need a solution

Desc:

We are trying to create a relation between 2 DBF tables. Both tables have an index named "IDREC" When we set the SetRelation command from the master to the detail table it is now working.

Code:

-- OPEN PARENT TABLE --

tableF = New ApolloTable()

[login to view URL] = "PATH TO TABLE"

[login to view URL] = "ALIAS FOR MASTER"

[login to view URL] = [login to view URL]

IDF = [login to view URL]()

[login to view URL](1900)

[login to view URL](0)

[login to view URL](True)

-- OPEN CHILD TABLE --

tableD = New ApolloTable()

[login to view URL] = "PATH TO TABLE"

[login to view URL] = "ALIAS FOR DETAIL"

[login to view URL] = [login to view URL]

ID = [login to view URL]()

[login to view URL](1900)

[login to view URL](0)

[login to view URL](True)

-- SET RELATION--

[login to view URL](ID, "IDREC")

-- TRY YO FILTER USING A INDEX IN THE DETAIL TABLE --

Qres = ApolloAPI.sx_Query(" Language='English' ")

-- WE ARE GETTING BACK ALL ROWS IN THE MASTER TABLE --

-- WE SHOULD GET JUST THE ONES MATCHING THE FILTER --

Needed

working code that we can comple

working exe to test

should open two dbs and set relation

then show a grid of the two dbs showing that the tables are joined and using indexes.

Also should be able to set a filter using setscope or set filter command to show it also using the set relation in those results.

Kemahiran: ASP.NET, Pelayan Microsoft SQL, Pengaturcaraan C#, .NET, SQL

Lihat lagi: wampserver set website help, apa style writing help for hire, best freelancing sites for programmers, build help for my website, complite help for ecommerce, computer help for social media in colorado springs, excel help for individuals, freelance help for google services, freelancer help for business adobe catylist, freelancing websites for programmers, graphic design help for small businesses, help for data entry, help for hire edit and margin book, help for installing active directory, how can i find marketing help for my business, looking for a sharepoint expert to help me set up sharepoint for my company we are a small team spread across different countrie, looking for programmers to help with php drupal, this system is not yet registered. try 'subscription-manager register --help' for more information., usage bench options command args try bench -- help for help error no such command new site, usage bench (options) command (args try bench --help'' for help error no such command new-site)

ID Projek: #28291932