Stored Procedure ???

[satakarimas]

I build a stored procedure in access involving 2 tables and when I launch the application on my local machine (visual studio local server) everything works fine... but when I upload the application I only see the total column in the grid.
http://toctoctoc.be/stevepigra/rapport.aspx
It uses the webdatagrid form infragistics but I have the same problem with datagrid in visual studio...
It seems that it's not a server related problem ? can someone can give me a hint or a solution ?

Thanks

[wisemx]

Hi,
I've done SP with Access in the past but on-line always with code not embedded in the Access DB.
Have you tried doing it that way?
All the best,
Mark

[satakarimas]

here is the code in access stored procedure :
--------------------
TRANSFORM Sum(RQOutCome.[Montant]) AS SommeDeMontant
SELECT RQOutCome.[NomFournisseur], Sum(RQOutCome.[Montant]) AS [Total de Montant]
FROM RQOutCome
GROUP BY RQOutCome.[NomFournisseur]
PIVOT Format([DateOperation],"mmm") In ("janv","févr","mars","avr","mai","juin","juil","août","sept","oct","nov","déc");
---------------------

you think I can do it manually in code behind and setting this code instead of the classic SELECT * FROM ... WHERE ... ?

The syntax doesn't have to modified ?
Thank you.

[wisemx]

Hi,
I could but I'm up to my neck right now and trying to catchup. ;-)
This is a good article showing how:
http://devcity.net/Articles/18/msaccess_sp.aspx
All the best,
Mark