Foxpro Driver for LLBLGEN v2.0

Posts   
1  /  2
 
    
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 27-Mar-2008 13:54:29   

TomV wrote:

Any idea when this will be?

I´m not sure. Currently I´m really busy with some other projects. I would also build the assemblies against v2.5 to see what happens confused

No matter, I´ll keep you up to date.

Which version of VFP are you running?

Regards, Carlo

TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 27-Mar-2008 14:38:09   

Ok, that's great.

The legacy application uses FoxPro 9 SP1

Kind regards, TomV

Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 28-Mar-2008 12:10:02   

Last night I can´t sleep.

That was the perfect moment for me to build the assemblies against v2.5. But there are two issues I can´t solve. I´m not sure if it´s a template problem confused Both issues are related to the shared-template section.

First prob:

DM.EntityClasses.AdressenEntity.GetRelatedData()": Die Zugriffsmodifizierer können beim Überschreiben des geerbten protected-members " SD.LLBLGen.Pro.ORMSupportClasses.EntityBase2.GetRelatedData()" nicht geändert werden.



        /// <summary>
        /// Gets all related data objects, stored by name. The name is the field name mapped onto the relation for that particular data element. 
        /// </summary>
        /// <returns>Dictionary with per name the related referenced data element, which can be an entity collection or an entity or null</returns>
        public override Dictionary<string, object> GetRelatedData()
        {
            Dictionary<string, object> toReturn = new Dictionary<string, object>();
            toReturn.Add("Adressen", _adressen);



            return toReturn;
        }



if I change public to protected it seems to work.

Second prob:

Die beste Übereinstimmung für die überladene SD.LLBLGen.Pro.ORMSupportClasses.IFieldInfoProvider.GetEntityFields(string, SD.LLBLGen.Pro.ORMSupportClasses.IEntityFields2)-Methode hat einige ungültige Argumente.


        /// <summary>General factory entrance method which will return an EntityFields object with the format generated by the factory specified</summary>
        /// <param name="relatedEntityType">The type of entity the fields are for</param>
        /// <returns>The IEntityFields2 instance requested</returns>
        public static IEntityFields2 CreateEntityFieldsObject(EntityType relatedEntityType)
        {
            IEntityFields2 fieldsToReturn=null;
            IInheritanceInfoProvider inheritanceProvider = InheritanceInfoProviderSingleton.GetInstance();
            IFieldInfoProvider fieldProvider = FieldInfoProviderSingleton.GetInstance();
            switch(relatedEntityType)
            {
                case DM.EntityType.AdressenEntity:
                    fieldsToReturn = fieldProvider.GetEntityFields(inheritanceProvider, "AdressenEntity");
                    break;
            }
            return fieldsToReturn;
        }

I am really struggling frowning

I hope Otis has some hints for me smile

Regards, Carlo

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39615
Joined: 17-Aug-2003
# Posted on: 28-Mar-2008 22:31:20   

My german is very rusty, besides aus auser bei mit nag seit von zu wink

I think the best you can do is use a diff tool like windiff and compare the sqlserver templates for entities of v2.0 and v2.5. Then migrate hte changes over to your templates.

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 31-Mar-2008 09:30:33   

Otis wrote:

My german is very rusty, besides aus auser bei mit nag seit von zu wink

It sounds like a mystery for me wink

Otis wrote:

I think the best you can do is use a diff tool like windiff and compare the sqlserver templates for entities of v2.0 and v2.5. Then migrate hte changes over to your templates.

Thanks Otis, I give it a try. But why should I compare the specific templates? The posted code is generated form the shared templates.

Thank you in advance.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39615
Joined: 17-Aug-2003
# Posted on: 31-Mar-2008 10:13:05   

Rushmore wrote:

Otis wrote:

My german is very rusty, besides aus auser bei mit nag seit von zu wink

It sounds like a mystery for me wink

ha! And we, the dutch, suffer in schools to learn German while the Germans kick out the namefalls out of their language ? wink

Otis wrote:

I think the best you can do is use a diff tool like windiff and compare the sqlserver templates for entities of v2.0 and v2.5. Then migrate hte changes over to your templates.

Thanks Otis, I give it a try. But why should I compare the specific templates? The posted code is generated form the shared templates.

Thank you in advance.

Then you don't have to port anything, as they're shared. I was under the impression you were looking what to change in the specific templates. I didn't look closely where the code came from. So that code falls under the 'breaking changes' in v2.5.

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 31-Mar-2008 11:26:50   

Otis wrote:

Rushmore wrote:

Otis wrote:

My german is very rusty, besides aus auser bei mit nag seit von zu wink

It sounds like a mystery for me wink

ha! And we, the dutch, suffer in schools to learn German while the Germans kick out the namefalls out of their language ? wink

Now it´s clear (I hope) - you talk about the "Kasus" Dativ, Genitiv etc.

Otis wrote:

I think the best you can do is use a diff tool like windiff and compare the sqlserver templates for entities of v2.0 and v2.5. Then migrate hte changes over to your templates.

Thanks Otis, I give it a try. But why should I compare the specific templates? The posted code is generated form the shared templates.

Thank you in advance.

Then you don't have to port anything, as they're shared. I was under the impression you were looking what to change in the specific templates. I didn't look closely where the code came from. So that code falls under the 'breaking changes' in v2.5.

Mmh? I guess the shared templates and the 'breaking changes' are working together simple_smile Any suggestions?

Sorry for my experimental english flushed

TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 17-May-2010 14:30:38   

Hi Guys,

Two years and a brand new computer later this customer project became active again disappointed The customer needs a little extension.

In our source repository I only have the foxpro driver dll, but I miss the driver configuration file etc... So I would like to download the sources once more. But it seems that I'm unable to connect to the SVN server...

svn: //www.sd.nl/LLBLGenPro/CustomDrivers/FoxPro/v2.0

Are these sources still online?

Best regards, TomV

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39615
Joined: 17-Aug-2003
# Posted on: 17-May-2010 17:41:47   

No, and they won't be put online in the future as well...

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 17-May-2010 17:59:29   

Who are they? You or me ;-)

I´ve build the Driver, DQE, and templates for v2.6. I hope it will still work with v3.0.

Kind regards Carlo

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39615
Joined: 17-Aug-2003
# Posted on: 17-May-2010 20:31:55   

Rushmore wrote:

Who are they? You or me ;-)

haha smile

'they' == the sources. They're very outdated (what we had in the repository)

I´ve build the Driver, DQE, and templates for v2.6. I hope it will still work with v3.0.

Did you share them here, I don't recall the exact location where they can be obtained or if you send them to us (please forgive me if you did sent them)

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 17-May-2010 22:35:06   

Otis wrote:

Rushmore wrote:

Who are they? You or me ;-)

haha smile

'they' == the sources. They're very outdated (what we had in the repository)

I´ve build the Driver, DQE, and templates for v2.6. I hope it will still work with v3.0.

Did you share them here, I don't recall the exact location where they can be obtained or if you send them to us (please forgive me if you did sent them)

I will send you the driver, DQE and templates tomorrow.

And what do you think, If I say I can also generate code to access SQlite3 databases (.NET35/CF35)?

Good night ....

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39615
Joined: 17-Aug-2003
# Posted on: 19-May-2010 10:01:39   

received them. Will clean the zips a bit and publish them in the customer area under 3rd party simple_smile

SQLite is a bit problematic, as SQLite doesn't support right-joins and our runtime converts left joins to right joins if necessary. But I won't stop you btw wink .

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 19-May-2010 11:06:25   

Otis wrote:

received them. Will clean the zips a bit and publish them in the customer area under 3rd party simple_smile

SQLite is a bit problematic, as SQLite doesn't support right-joins and our runtime converts left joins to right joins if necessary. But I won't stop you btw wink .

We are using only simple queries with SQLite on the PocketPC.

TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 19-May-2010 13:49:17   

Thanks Rushmore and Otis!

I will monitor the 3rd party download area... After download I will store them in our vault smile

Best regards, TomV

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39615
Joined: 17-Aug-2003
# Posted on: 19-May-2010 17:21:57   

It's available simple_smile Have fun simple_smile (customer area -> v2.6 -> 3rd party -> MS Fox pro support)

Frans Bouma | Lead developer LLBLGen Pro
1  /  2