[Mono-list] SQLLite problem

Paul Johnson paul at all-the-johnsons.co.uk
Thu Mar 14 16:33:36 UTC 2013


Hi,

> My guess, there is an escape character or SQLite syntax issues in the
> previous field being supplied. The Siblings value may be the issue, but
> that is just a quick guess.

That was another thought. Replace(Environment.NewLine, "") didn't clear 
the issue. Here is an example of one of the records

<BoyRecord>
<BoyID>1</BoyID>
<ReplicationID>{D3F47464-E549-4A6F-88BE-3B45BA8F7885}</ReplicationID>
<MoneyID>4</MoneyID>
<AffiliationID>5</AffiliationID>
<Affiliation1ID>9</Affiliation1ID>
<DescriptionID>11</DescriptionID>
<Description1ID>7</Description1ID>
<LastName>Bouhadana</LastName>
<FirstName>Dovid Yosef</FirstName>
<DateOfBirth>1981-05-01T00:00:00</DateOfBirth>
<Calculated>0</Calculated>
<Height>72</Height>
<City>Flatbush</City>
<Country>USA</Country>
<Phone1>718-757-6890</Phone1>
<Yeshiva1>Chaim Berlin    Lakewood East</Yeshiva1>
<Yeshiva2>Nachlas Moshe</Yeshiva2>
<Yeshiva3>Now In BMG</Yeshiva3>
<Working>0</Working>
<FathersName>Mordechai</FathersName>
<FathersOrigin>Morroco</FathersOrigin>
<FathersJob>Shochet - Sofer</FathersJob>
<FathersShull>Bnei Yosef</FathersShull>
<MothersName>Rivka</MothersName>
<MothersMaidenName>Ohayon</MothersMaidenName>
<MothersOrigin>Morroco</MothersOrigin>
<OrderInFamily>6</OrderInFamily>
<FamilySize>6</FamilySize>
<Mechutanim>Sister - Azar - Rochester
Sister - Mordechai - Brooklyn
Sister - Ben Attar - Israel
Son - Dahan - Canada
Son - Kastika - Brooklyn</Mechutanim>
<References>R' Yaakov Bachrach: 914-879-6022
Eli Berman: 718-490-6606</References>
<DateAdded>2007-06-21T00:00:00</DateAdded>
<Engaged>0</Engaged>
<UpdateNo>0</UpdateNo>
</BoyRecord>

The replicationID GUID is taken as a string and converted to a GUID 
within the BoyRecords class with the Guid field set to [Ignore()]

Paul
-- 
"Space," it says, "is big. Really big. You just won't believe how 
vastly, hugely, mindbogglingly big it is. I mean, you may think it's a 
long way down the road to the chemist's, but that's just peanuts to 
space, listen..."
Hitch Hikers Guide to the Galaxy, a truly remarkable book!



More information about the Mono-list mailing list