| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> well time to go home. night all.
<1> imorxr sure was interesting a few hours ago. made me lol
<2> yo yo
<2> wssup
<2> long time, teychom yo yo
<3> teh OuTcasTr
<2> hello, boot
<2> i miss u guys
<2> xo
<2> xo xo xo xo
<3> so, why so long?
<2> ine
<2> fine
<2> i am on egypt
<2> now
<2> having FUUUUN
<3> why egypt?
<2> cuz i manage to get out of my f* darfour
<3> you from sudan?
<2> yeah
<3> ic
<2> i making will do vb.net 70-306 , next week wich me luck ppl
<2> so damn complex
<2> no
<2> not very
<2> but it's 2 big
<2> anyway
<2> gtg ,, nice seeing ya all xo
<2> peace out ,,
<2> xo
<4> hey everybody... is anyone around to answer a question?
<4> This is a more advanced topic, so if this person that can help me would have to be pretty good. Anyone around know a lot about ADO?
<4> is anyone around here?
<5> ado is an advanced topic? heheh
<4> lol
<4> well... my question is
<4> i'm using VB 6.0 ADO 2.5
<4> I have this recordset. Clientside cursor, optimistic locking.
<4> i use the recordset.sort property to sort the recordset. Then i loop through the recordset and update the fields that i need
<4> one of the fields that i update is one that was in the sort option.
<4> as soon as i do that, it recalculates the sort and my absolute position changes... thus causeing me to miss records while i loop to EOF
<3> why not use sql and order the query as needed
<3> ado intrinsic methods are clunky imho, I always execute sql statements
<4> imho?
<3> in my honest opinion
<4> actually... sort is very efficient, because it does not physically resort the table
<3> why not ask for a recordset already sorted
<4> because i have to use it for many different things
<3> I think useing sql's "order by" may be more efficient than .sort, nor does it physically reorder the table, just provides you a recordset allready sorted
<6> heloo
<7> so loop until every record has been updated
<6> I'm wondering if anyone has run into a situation where sql server 2000 (SP4) would not recognize LongVarWChar as a datatype?
<7> if the first run gets most, then the second one won't take much
<7> third could be almost non existant
<6> I've looked into google and have found nothing useful so far... has anyone run into this by chance?
<7> Mark43: you're going to have to be more specific
<6> I'm trying to create a query in SQL Server that takes a parameter for blob (datatype number 203, I believe) which is LongVarWChar according to the docs. however when I try to save the procedure SQL Server complains that it does not recgonize LongVarWChar as a datatype.
<6> I installed SP4 but that didn't help.
<6> not sure where to go with this. Tried google but there's not much there on this datatype and I haven't found anything that describes my problem so far. Do you know off hand what data type I should use to store the equivalent of a ms access memo field?
<4> Teycho... looping through all the recordsets 3 more times is not something that i can do. I guess, i just want to disable the automatic resorting aspect of the ADO driver
<4> SQL Server 2000's equivelent to an Access memo is Text
<6> ok
<4> if you create your table with enterprise manager, it is real easy
<6> I upsized an access database
<6> used Import Wizard
<6> had some memo fields and I guess the import wizard translated them to LongVarWChar
<6> but what is the W?
<6> Not sure what the distinction between LongVarWChar and LongVarChar would be.
<6> any idea?
<3> unicode prolly
<6> also should I use LongVarChar you think?
<6> Basically I want to store a whole buncha text data
<7> blahblahb: so unsort, then resort
<7> How many records?
<4> Mark43: Text is what you want
<6> I don't see "Text" as a datatype option... hold on. I'm going to double check.
<4> Mark43: it only cost 16 bytes and then grows with the size of the text
<6> do you mean varchar?
<4> no
<6> ok
<6> I see it
<6> thanks
<4> yeap
<6> the wizard made them nText
<6> so that's unicode
<6> which might explain why it got the LongVarWChar ***ignment. I'm wondering why that doens't work though.
<6> is there something I need to install?
<4> sounds like you need to upgrade your wizard
<4> :-)
<3> I think W implys WIDE BYTE, meaning 2 byte character, a unicode character
<6> ah
<6> ok
<6> when you say upgrade my wizard... not sure how to do that...
<6> well maybe I'll just change these things to text and let it go at that.
<4> i was joking
<6> k
<4> that would be what i would do
<6> ok
<6> sounds like a plan
<4> but... then again... i'm in here looking for help... so take my advise for what it's worth
<4> not much
<6> oh one thing - if i do go multinational with this project then I am guessing I will need unicode later. maybe i should figure out and resolve the issue itself instead of workarounding it away
<6> sorry for inventing that word ... it was pretty bad.
<4> yea, i dont know the implencations to using unicode vr whatever... but, i think you will be safe with Text. it should work both ways
<6> well I guess i can cross that bridge when i get to it. wouldn't be for a year or more anyway
<6> hm. i changed all the ntext to text and then reran the query with a LongVarChar. same problem except now it says "Cannot find data type LongVarChar".
<6> interestingly that string reveals 2 obsolete web references from google. and that's it.
<6> google groups gets zero.
<3> is tyhis a access database?
<6> sql server
<6> 2000
<6> sp4
<6> just installed today
<3> try either nvarchar or varchar
<6> so far i've tried both
<6> neither works
<6> seems like something might be missing from my installation because this is not a common problem.
<3> what about text and ntext
<6> oh
<6> i changed both ntext and nvarchar to text and varchar in the datatypes of all the tables
<6> however the change does not appear to have made any difference in regards to the issue.
<6> for some reason the database seems to not be able to recognize or find LongVarChar or LongVarWChar as a datatype.
<3> your using a blob?
<6> no
<6> I upgraded an MS Access database with the Import Wizard. I thought they would be blobs but it turns out they were nText.
<6> when i went to create a parameter query and tried using the datatype for the parameter LongVarChar an error is produced saying "Cannot find the data type LongVarChar".
<6> which I've never seen before.
<6> apparently no one else has either because there's nothing on it in google.
<6> which is another thing that i find odd.
<3> welp LongWVarChar and LongVarChar would be read as ntext and text
<6> i would think
<3> is it textual or binary data
<3> as blob also implys binary data, or image
<6> yup following you
<6> but the question is how to fix it
<3> welp, you mentioned blob
<3> did you also try "image"
<6> nope. my guess is that this is some sort of installation problem or configuration issue
<6> well a long search on google didn't provide much in the way of info
<6> :(
<8> mmm
<8> mm
<9> mm
<8> W***up?
<9> Nothing.
<9> ;o
<9> Applied for a visa today.
<9> so i can buy stuff.
<8> mhm
Return to
#vb
or
Go to some related
logs:
#worldchat
şakadan
mayami
#india
#linux
info on the yid army
#allnitecafe
#linux
#allnitecafe
#netcafe
|
|