f# - F sharp saving record type into access db -

-

i have following record type "tbl" , contain lists or seq. how can save/update "tbl" existing access db table using f sharp field names specified below.

type tbl= {     p:string;                  in:system.datetime;                  ex:system.datetime;                 b:string;                  cc:string;                  gg:double;                  pr:double;                 de:double;                 pre:double;                  deu:double;                  prpl_deduc:double;                  gur:double;                  gc:double;                  prp:double;                  pda:double;                  pro:double}  let conn = new oledbconnection( @"provider=microsoft.ace.oledb.12.0;           data source=t:\test.accdb;            persist security info=false;" ) conn.open()      let sql="insert test select * " tbl let dadapter = new oledbdataadapter(sql,conn) dadapter.update

there's couple of things come mind here.

firstly, think you're tripping on interpretation of record type - isn't recordset - can't pump oledbdataadapter.

there's not support access in f# type providers - i'm losing touch how many there example sqlprovider lets read access not perform crud actions.

so, @ least far know, old fashioned oledb approach you've got above right path here.

the code below uses sqlprovider retrieve contents of access db 3 columns, savearow function won't work , goes on oledb way...

#r @"packages\sqlprovider.0.0.9-alpha\lib\net40\fsharp.data.sqlprovider.dll"  open system open system.linq open fsharp.data.sql  [<literal>] let cnstr = @"provider=microsoft.ace.oledb.12.0;data source=c:\temp\database1.accdb;persist security info=false;"  type sql = sqldataprovider<                 connectionstring = @"provider=microsoft.ace.oledb.12.0;data source=c:\temp\database1.accdb;persist security info=false;",                 databasevendor = common.databaseprovidertypes.msaccess> let ctx = sql.getdatacontext()  // return data ctx.``[database1].[table1]`` |> seq.take 1  // create type represent data type row = {p: string; in:system.datetime; gg:double}  // insert more data p:string, in:datetime, ex:datetime, b:string, gg:number // unfortunately sqldataprovider doesn't support crud operations on ms access... let savearow (arow: row) =     let table1 = ctx.``[database1].[table1]``.create()     table1.p <- arow.p     table1.in <- arow.in     table1.gg <- arow.gg     ctx.submitupdates()  {p="abc"; in=datetime.now; gg=200.} |> savearow  // try old fashioned way open system.data open system.data.oledb  #r @"c:\program files (x86)\reference assemblies\microsoft\framework\.netframework\v4.5.2\system.transactions.dll" open system.transactions  let savearow2(arow: row) =     let cn = new oledbconnection(cnstr)     cn.open()     let cmd = new oledbcommand()     cmd.commandtype <- commandtype.text     let insertcmd = sprintf "insert table1 values ('%s', '%s', '%f')" arow.p (arow.in.toshortdatestring()) arow.gg     cmd.commandtext <- insertcmd     cmd.connection <- cn     cmd.executenonquery() |>ignore     cn.close()  {p="abcd"; in=datetime.now; gg=200.} |> savearow2

Comments

Post a Comment

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

-
Image
i have similar problem described in how prevent numbers being changed exponential form in python matplotlib figure : i don't want (in special case) weird scientific formatting of axis. problem different have problem @ z -axis. 2-d plots can use ax.get_yaxis().get_major_formatter().set_useoffset(false) . , there no function ax.get_zaxis() what use format z -axis same way? edit: example: from mpl_toolkits.mplot3d import axes3d import numpy np import sys import matplotlib import matplotlib.pyplot pyplot def func(xi, ti): res = 10e3 + np.cos(ti) * np.sin(xi) return res if __name__ == '__main__': timespacing = 20 timestart = 0 timeend = 1 time = np.linspace(timestart, timeend, timespacing) widthspacing = 50 widthstart = 0 widthend = 3 width = np.linspace(widthstart, widthend, widthspacing) reslist = [] matplotlib.rcparams['legend.fontsize'] = 10 fig = pyplot.figure() ax = fig.gca(projection = '3d...
Read more

php - Best Light server (Linux + Web server + Database) for Raspberry Pi -

-
i install web server database on raspberry pi (little computer). computer has 1gb ram. i want know best combination: linux distribution , web server , dbms run local server multiple users minimal latency, use php on server. , best settings performance , not have bugs (memory usage, disable plugin, disable service, etc)? i thought light debian , lighttpd server , sqlite database. solution? i think lighttpd + sqlite great choice. linux distro, debian @ centos or tiny core linux , although i'm not sure of compatibility pi. obviously, can't go wrong raspbian if want use in production , more stable performance, few more pi's , set them in cluster .
Read more

c# - "Newtonsoft.Json.JsonSerializationException unable to find constructor to use for types" error when deserializing class -

-
i developing app in xamarin android. have splash screen serialize class , pass mainactivity using intent . when try deserialize in mainactivity error message : "serializationexception unable find constructor use types" serialization : void loaddata() { currency currency = new currency(this); intent = new intent(this, typeof(mainactivity)); intent.putextra("currency", newtonsoft.json.jsonconvert.serializeobject(currency)); startactivity(intent); } deserialization : cur = newtonsoft.json.jsonconvert.deserializeobject<currency> (intent.getstringextra("currency")); // error here class constructor : public currency(context context) { thiscontext = context; } i began experiencing problem after added parameter context context constructor. has caused this? how can solve it? possible serialize/deserialize class has parameters? you need have empty constructor in currency class in order deserialize it. ...
Read more