En cours

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.

Compétences : ASP.NET, Serveur SQL Microsoft, Programmation C#, .NET, SQL

en voir plus : 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)

Concernant l'employeur :
( 25 commentaires ) WHITTIER, United States

Nº du projet : #28291932

Décerné à:

Rota66

Hi there, I saw your code and successfully replicated the ApolloDB "erroneous behavior", take a look at: [login to view URL] [login to view URL] [login to view URL] I have for many Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(0 Commentaires)
0.0

9 freelances font une offre moyenne de 349 $ pour ce travail

(124 Commentaires)
8.2
(4 Commentaires)
4.8
yanakhokhlova199

Hello there. I am very interested in your project. *** As C#, ASP NET MVC, CORE expert ***, So I can handle this and am confident of winning. I have rich experience in this field and if you give a chance, perfect re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
4.5
RaceteqUnion

Hi, Asp.net is our main expertise and interested in helping you to Create ASP.net application that takes two dbf and joins them via set relation command in apollodb, as I have got expertise with C#, .Net Core 2.2,3.1, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(3 Commentaires)
3.4
KBIZSolutions

Hi Greeting for the day.! I read your project description but could not find enough details to estimate the effort. However, I have extensive experience in asp.net/mvc/angular and I can deliver you quality work. Let's Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
2.3
Developershub006

Hello Dear...! Alert: I will give you 20% discount on my bid rate also give on my All Services. So grabs this special offer is limited. Let’s get to the point. I came to know that your Looking a developer which hav Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
0.0
kapoorravi497

i accepted your opportunity my experience is 12 year of [login to view URL] contact me your work is completed at require time

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
Dhaval81099

recently i completed computer and i made project on sql and i want to lean more so please give me this project for free, i am ready to do free of cost

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0